/*
 Navicat Premium Dump SQL

 Source Server         : postgresql
 Source Server Type    : PostgreSQL
 Source Server Version : 170004 (170004)
 Source Host           : localhost:5432
 Source Catalog        : pig
 Source Schema         : pig

 Target Server Type    : PostgreSQL
 Target Server Version : 170004 (170004)
 File Encoding         : 65001

 Date: 29/06/2025 16:52:04
*/


-- ----------------------------
-- Table structure for QRTZ_BLOB_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS "pig"."QRTZ_BLOB_TRIGGERS";
CREATE TABLE "pig"."QRTZ_BLOB_TRIGGERS" (
  "SCHED_NAME" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "TRIGGER_NAME" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "TRIGGER_GROUP" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "BLOB_DATA" bytea
)
;
ALTER TABLE "pig"."QRTZ_BLOB_TRIGGERS" OWNER TO "postgres";

-- ----------------------------
-- Records of QRTZ_BLOB_TRIGGERS
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_CALENDARS
-- ----------------------------
DROP TABLE IF EXISTS "pig"."QRTZ_CALENDARS";
CREATE TABLE "pig"."QRTZ_CALENDARS" (
  "SCHED_NAME" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "CALENDAR_NAME" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "CALENDAR" bytea NOT NULL
)
;
ALTER TABLE "pig"."QRTZ_CALENDARS" OWNER TO "postgres";

-- ----------------------------
-- Records of QRTZ_CALENDARS
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_CRON_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS "pig"."QRTZ_CRON_TRIGGERS";
CREATE TABLE "pig"."QRTZ_CRON_TRIGGERS" (
  "SCHED_NAME" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "TRIGGER_NAME" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "TRIGGER_GROUP" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "CRON_EXPRESSION" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "TIME_ZONE_ID" varchar(80) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "pig"."QRTZ_CRON_TRIGGERS" OWNER TO "postgres";

-- ----------------------------
-- Records of QRTZ_CRON_TRIGGERS
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_FIRED_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS "pig"."QRTZ_FIRED_TRIGGERS";
CREATE TABLE "pig"."QRTZ_FIRED_TRIGGERS" (
  "SCHED_NAME" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "ENTRY_ID" varchar(95) COLLATE "pg_catalog"."default" NOT NULL,
  "TRIGGER_NAME" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "TRIGGER_GROUP" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "INSTANCE_NAME" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "FIRED_TIME" int8 NOT NULL,
  "SCHED_TIME" int8 NOT NULL,
  "PRIORITY" int4 NOT NULL,
  "STATE" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
  "JOB_NAME" varchar(200) COLLATE "pg_catalog"."default",
  "JOB_GROUP" varchar(200) COLLATE "pg_catalog"."default",
  "IS_NONCONCURRENT" varchar(1) COLLATE "pg_catalog"."default",
  "REQUESTS_RECOVERY" varchar(1) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "pig"."QRTZ_FIRED_TRIGGERS" OWNER TO "postgres";

-- ----------------------------
-- Records of QRTZ_FIRED_TRIGGERS
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_JOB_DETAILS
-- ----------------------------
DROP TABLE IF EXISTS "pig"."QRTZ_JOB_DETAILS";
CREATE TABLE "pig"."QRTZ_JOB_DETAILS" (
  "SCHED_NAME" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "JOB_NAME" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "JOB_GROUP" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "DESCRIPTION" varchar(250) COLLATE "pg_catalog"."default",
  "JOB_CLASS_NAME" varchar(250) COLLATE "pg_catalog"."default" NOT NULL,
  "IS_DURABLE" varchar(1) COLLATE "pg_catalog"."default" NOT NULL,
  "IS_NONCONCURRENT" varchar(1) COLLATE "pg_catalog"."default" NOT NULL,
  "IS_UPDATE_DATA" varchar(1) COLLATE "pg_catalog"."default" NOT NULL,
  "REQUESTS_RECOVERY" varchar(1) COLLATE "pg_catalog"."default" NOT NULL,
  "JOB_DATA" bytea
)
;
ALTER TABLE "pig"."QRTZ_JOB_DETAILS" OWNER TO "postgres";

-- ----------------------------
-- Records of QRTZ_JOB_DETAILS
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_LOCKS
-- ----------------------------
DROP TABLE IF EXISTS "pig"."QRTZ_LOCKS";
CREATE TABLE "pig"."QRTZ_LOCKS" (
  "SCHED_NAME" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "LOCK_NAME" varchar(40) COLLATE "pg_catalog"."default" NOT NULL
)
;
ALTER TABLE "pig"."QRTZ_LOCKS" OWNER TO "postgres";

-- ----------------------------
-- Records of QRTZ_LOCKS
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
DROP TABLE IF EXISTS "pig"."QRTZ_PAUSED_TRIGGER_GRPS";
CREATE TABLE "pig"."QRTZ_PAUSED_TRIGGER_GRPS" (
  "SCHED_NAME" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "TRIGGER_GROUP" varchar(200) COLLATE "pg_catalog"."default" NOT NULL
)
;
ALTER TABLE "pig"."QRTZ_PAUSED_TRIGGER_GRPS" OWNER TO "postgres";

-- ----------------------------
-- Records of QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_SCHEDULER_STATE
-- ----------------------------
DROP TABLE IF EXISTS "pig"."QRTZ_SCHEDULER_STATE";
CREATE TABLE "pig"."QRTZ_SCHEDULER_STATE" (
  "SCHED_NAME" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "INSTANCE_NAME" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "LAST_CHECKIN_TIME" int8 NOT NULL,
  "CHECKIN_INTERVAL" int8 NOT NULL
)
;
ALTER TABLE "pig"."QRTZ_SCHEDULER_STATE" OWNER TO "postgres";

-- ----------------------------
-- Records of QRTZ_SCHEDULER_STATE
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS "pig"."QRTZ_SIMPLE_TRIGGERS";
CREATE TABLE "pig"."QRTZ_SIMPLE_TRIGGERS" (
  "SCHED_NAME" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "TRIGGER_NAME" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "TRIGGER_GROUP" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "REPEAT_COUNT" int8 NOT NULL,
  "REPEAT_INTERVAL" int8 NOT NULL,
  "TIMES_TRIGGERED" int8 NOT NULL
)
;
ALTER TABLE "pig"."QRTZ_SIMPLE_TRIGGERS" OWNER TO "postgres";

-- ----------------------------
-- Records of QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS "pig"."QRTZ_SIMPROP_TRIGGERS";
CREATE TABLE "pig"."QRTZ_SIMPROP_TRIGGERS" (
  "SCHED_NAME" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "TRIGGER_NAME" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "TRIGGER_GROUP" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "STR_PROP_1" varchar(512) COLLATE "pg_catalog"."default",
  "STR_PROP_2" varchar(512) COLLATE "pg_catalog"."default",
  "STR_PROP_3" varchar(512) COLLATE "pg_catalog"."default",
  "INT_PROP_1" int4,
  "INT_PROP_2" int4,
  "LONG_PROP_1" int8,
  "LONG_PROP_2" int8,
  "DEC_PROP_1" numeric(13,4),
  "DEC_PROP_2" numeric(13,4),
  "BOOL_PROP_1" varchar(1) COLLATE "pg_catalog"."default",
  "BOOL_PROP_2" varchar(1) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "pig"."QRTZ_SIMPROP_TRIGGERS" OWNER TO "postgres";

-- ----------------------------
-- Records of QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS "pig"."QRTZ_TRIGGERS";
CREATE TABLE "pig"."QRTZ_TRIGGERS" (
  "SCHED_NAME" varchar(120) COLLATE "pg_catalog"."default" NOT NULL,
  "TRIGGER_NAME" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "TRIGGER_GROUP" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "JOB_NAME" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "JOB_GROUP" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "DESCRIPTION" varchar(250) COLLATE "pg_catalog"."default",
  "NEXT_FIRE_TIME" int8,
  "PREV_FIRE_TIME" int8,
  "PRIORITY" int4,
  "TRIGGER_STATE" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
  "TRIGGER_TYPE" varchar(8) COLLATE "pg_catalog"."default" NOT NULL,
  "START_TIME" int8 NOT NULL,
  "END_TIME" int8,
  "CALENDAR_NAME" varchar(200) COLLATE "pg_catalog"."default",
  "MISFIRE_INSTR" int2,
  "JOB_DATA" bytea
)
;
ALTER TABLE "pig"."QRTZ_TRIGGERS" OWNER TO "postgres";

-- ----------------------------
-- Records of QRTZ_TRIGGERS
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for gen_datasource_conf
-- ----------------------------
DROP TABLE IF EXISTS "pig"."gen_datasource_conf";
CREATE TABLE "pig"."gen_datasource_conf" (
  "id" int8 NOT NULL,
  "name" varchar(64) COLLATE "pg_catalog"."default",
  "url" varchar(255) COLLATE "pg_catalog"."default",
  "username" varchar(64) COLLATE "pg_catalog"."default",
  "password" varchar(64) COLLATE "pg_catalog"."default",
  "create_time" timestamp(6),
  "update_time" timestamp(6),
  "del_flag" char(1) COLLATE "pg_catalog"."default",
  "ds_type" varchar(64) COLLATE "pg_catalog"."default",
  "conf_type" char(1) COLLATE "pg_catalog"."default",
  "ds_name" varchar(64) COLLATE "pg_catalog"."default",
  "instance" varchar(64) COLLATE "pg_catalog"."default",
  "port" int4,
  "host" varchar(128) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "pig"."gen_datasource_conf" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."gen_datasource_conf"."id" IS '主键';
COMMENT ON COLUMN "pig"."gen_datasource_conf"."name" IS '别名';
COMMENT ON COLUMN "pig"."gen_datasource_conf"."url" IS 'jdbcurl';
COMMENT ON COLUMN "pig"."gen_datasource_conf"."username" IS '用户名';
COMMENT ON COLUMN "pig"."gen_datasource_conf"."password" IS '密码';
COMMENT ON COLUMN "pig"."gen_datasource_conf"."create_time" IS '创建时间';
COMMENT ON COLUMN "pig"."gen_datasource_conf"."update_time" IS '更新';
COMMENT ON COLUMN "pig"."gen_datasource_conf"."del_flag" IS '删除标记';
COMMENT ON COLUMN "pig"."gen_datasource_conf"."ds_type" IS '数据库类型';
COMMENT ON COLUMN "pig"."gen_datasource_conf"."conf_type" IS '配置类型';
COMMENT ON COLUMN "pig"."gen_datasource_conf"."ds_name" IS '数据库名称';
COMMENT ON COLUMN "pig"."gen_datasource_conf"."instance" IS '实例';
COMMENT ON COLUMN "pig"."gen_datasource_conf"."port" IS '端口';
COMMENT ON COLUMN "pig"."gen_datasource_conf"."host" IS '主机';
COMMENT ON TABLE "pig"."gen_datasource_conf" IS '数据源表';

-- ----------------------------
-- Records of gen_datasource_conf
-- ----------------------------
BEGIN;
INSERT INTO "pig"."gen_datasource_conf" ("id", "name", "url", "username", "password", "create_time", "update_time", "del_flag", "ds_type", "conf_type", "ds_name", "instance", "port", "host") VALUES (1935502655401222146, 'park_postgres', 'jdbc:postgresql://127.0.0.1:5432/parkingdb?currentSchema=pig&useUnicode=true&tcpKeepAlive=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai&reWriteBatchedInserts=true', 'postgres', 'r0PQHy8XozM4zAMJ2+7rj5M7cm+tO0su', '2025-06-19 08:59:27.606587', NULL, '0', 'postgres', '0', 'dev', '', 3306, 'localhost');
COMMIT;

-- ----------------------------
-- Table structure for gen_field_type
-- ----------------------------
DROP TABLE IF EXISTS "pig"."gen_field_type";
CREATE TABLE "pig"."gen_field_type" (
  "id" int8 NOT NULL,
  "column_type" varchar(200) COLLATE "pg_catalog"."default",
  "attr_type" varchar(200) COLLATE "pg_catalog"."default",
  "package_name" varchar(200) COLLATE "pg_catalog"."default",
  "create_time" timestamp(6),
  "create_by" varchar(64) COLLATE "pg_catalog"."default",
  "update_time" timestamp(6),
  "update_by" varchar(64) COLLATE "pg_catalog"."default",
  "del_flag" char(1) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "pig"."gen_field_type" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."gen_field_type"."id" IS '主键';
COMMENT ON COLUMN "pig"."gen_field_type"."column_type" IS '字段类型';
COMMENT ON COLUMN "pig"."gen_field_type"."attr_type" IS '属性类型';
COMMENT ON COLUMN "pig"."gen_field_type"."package_name" IS '属性包名';
COMMENT ON COLUMN "pig"."gen_field_type"."create_time" IS '创建时间';
COMMENT ON COLUMN "pig"."gen_field_type"."create_by" IS '创建人';
COMMENT ON COLUMN "pig"."gen_field_type"."update_time" IS '修改时间';
COMMENT ON COLUMN "pig"."gen_field_type"."update_by" IS '修改人';
COMMENT ON COLUMN "pig"."gen_field_type"."del_flag" IS '删除标记';
COMMENT ON TABLE "pig"."gen_field_type" IS '字段类型管理';

-- ----------------------------
-- Records of gen_field_type
-- ----------------------------
BEGIN;
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (1, 'datetime', 'LocalDateTime', 'java.time.LocalDateTime', '2023-02-06 08:45:10', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (2, 'date', 'LocalDate', 'java.time.LocalDate', '2023-02-06 08:45:10', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (3, 'tinyint', 'Integer', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (4, 'smallint', 'Integer', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (5, 'mediumint', 'Integer', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (6, 'int', 'Integer', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (7, 'integer', 'Integer', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (8, 'bigint', 'Long', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (9, 'float', 'Float', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (10, 'double', 'Double', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (11, 'decimal', 'BigDecimal', 'java.math.BigDecimal', '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (12, 'bit', 'Boolean', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (13, 'char', 'String', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (14, 'varchar', 'String', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (15, 'tinytext', 'String', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (16, 'text', 'String', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (17, 'mediumtext', 'String', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (18, 'longtext', 'String', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (19, 'timestamp', 'LocalDateTime', 'java.time.LocalDateTime', '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (20, 'NUMBER', 'Integer', NULL, '2023-02-06 08:45:11', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (21, 'BINARY_INTEGER', 'Integer', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (22, 'BINARY_FLOAT', 'Float', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (23, 'BINARY_DOUBLE', 'Double', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (24, 'VARCHAR2', 'String', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (25, 'NVARCHAR', 'String', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (26, 'NVARCHAR2', 'String', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (27, 'CLOB', 'String', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (28, 'int8', 'Long', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (29, 'int4', 'Integer', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (30, 'int2', 'Integer', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (31, 'numeric', 'BigDecimal', 'java.math.BigDecimal', '2023-02-06 08:45:12', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (32, 'json', 'String', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (33, 'serial8', 'Integer', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (34, 'bigserial', 'Integer', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (35, 'serial4', 'Integer', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0');
INSERT INTO "pig"."gen_field_type" ("id", "column_type", "attr_type", "package_name", "create_time", "create_by", "update_time", "update_by", "del_flag") VALUES (36, 'serial', 'Integer', NULL, '2023-02-06 08:45:12', NULL, NULL, NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for gen_group
-- ----------------------------
DROP TABLE IF EXISTS "pig"."gen_group";
CREATE TABLE "pig"."gen_group" (
  "id" int8 NOT NULL,
  "group_name" varchar(255) COLLATE "pg_catalog"."default",
  "group_desc" varchar(255) COLLATE "pg_catalog"."default",
  "create_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "update_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "create_time" timestamp(6),
  "update_time" timestamp(6),
  "del_flag" char(1) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "pig"."gen_group" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."gen_group"."group_name" IS '分组名称';
COMMENT ON COLUMN "pig"."gen_group"."group_desc" IS '分组描述';
COMMENT ON COLUMN "pig"."gen_group"."create_by" IS '创建人';
COMMENT ON COLUMN "pig"."gen_group"."update_by" IS '修改人';
COMMENT ON COLUMN "pig"."gen_group"."create_time" IS '创建人';
COMMENT ON COLUMN "pig"."gen_group"."update_time" IS '修改人';
COMMENT ON COLUMN "pig"."gen_group"."del_flag" IS '删除标记';
COMMENT ON TABLE "pig"."gen_group" IS '模板分组';

-- ----------------------------
-- Records of gen_group
-- ----------------------------
BEGIN;
INSERT INTO "pig"."gen_group" ("id", "group_name", "group_desc", "create_by", "update_by", "create_time", "update_time", "del_flag") VALUES (1, 'parking', '停车管理', 'admin', 'admin', '2025-07-13 19:36:40', '2025-07-13 19:36:49', '0');
COMMIT;

-- ----------------------------
-- Table structure for gen_table
-- ----------------------------
DROP TABLE IF EXISTS "pig"."gen_table";
CREATE TABLE "pig"."gen_table" (
  "id" int8 NOT NULL,
  "table_name" varchar(200) COLLATE "pg_catalog"."default",
  "class_name" varchar(200) COLLATE "pg_catalog"."default",
  "db_type" varchar(200) COLLATE "pg_catalog"."default",
  "table_comment" varchar(200) COLLATE "pg_catalog"."default",
  "author" varchar(200) COLLATE "pg_catalog"."default",
  "email" varchar(200) COLLATE "pg_catalog"."default",
  "package_name" varchar(200) COLLATE "pg_catalog"."default",
  "version" varchar(200) COLLATE "pg_catalog"."default",
  "i18n" char(1) COLLATE "pg_catalog"."default",
  "style" int8,
  "child_table_name" varchar(200) COLLATE "pg_catalog"."default",
  "main_field" varchar(200) COLLATE "pg_catalog"."default",
  "child_field" varchar(200) COLLATE "pg_catalog"."default",
  "generator_type" char(1) COLLATE "pg_catalog"."default",
  "backend_path" varchar(500) COLLATE "pg_catalog"."default",
  "frontend_path" varchar(500) COLLATE "pg_catalog"."default",
  "module_name" varchar(200) COLLATE "pg_catalog"."default",
  "function_name" varchar(200) COLLATE "pg_catalog"."default",
  "form_layout" int2,
  "ds_name" varchar(200) COLLATE "pg_catalog"."default",
  "baseclass_id" int8,
  "create_time" timestamp(6)
)
;
ALTER TABLE "pig"."gen_table" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."gen_table"."table_name" IS '表名';
COMMENT ON COLUMN "pig"."gen_table"."class_name" IS '类名';
COMMENT ON COLUMN "pig"."gen_table"."db_type" IS '数据库类型';
COMMENT ON COLUMN "pig"."gen_table"."table_comment" IS '说明';
COMMENT ON COLUMN "pig"."gen_table"."author" IS '作者';
COMMENT ON COLUMN "pig"."gen_table"."email" IS '邮箱';
COMMENT ON COLUMN "pig"."gen_table"."package_name" IS '项目包名';
COMMENT ON COLUMN "pig"."gen_table"."version" IS '项目版本号';
COMMENT ON COLUMN "pig"."gen_table"."i18n" IS '是否生成带有i18n 0 不带有 1带有';
COMMENT ON COLUMN "pig"."gen_table"."style" IS '代码风格';
COMMENT ON COLUMN "pig"."gen_table"."child_table_name" IS '子表名称';
COMMENT ON COLUMN "pig"."gen_table"."main_field" IS '主表关联键';
COMMENT ON COLUMN "pig"."gen_table"."child_field" IS '子表关联键';
COMMENT ON COLUMN "pig"."gen_table"."generator_type" IS '生成方式  0：zip压缩包   1：自定义目录';
COMMENT ON COLUMN "pig"."gen_table"."backend_path" IS '后端生成路径';
COMMENT ON COLUMN "pig"."gen_table"."frontend_path" IS '前端生成路径';
COMMENT ON COLUMN "pig"."gen_table"."module_name" IS '模块名';
COMMENT ON COLUMN "pig"."gen_table"."function_name" IS '功能名';
COMMENT ON COLUMN "pig"."gen_table"."form_layout" IS '表单布局  1：一列   2：两列';
COMMENT ON COLUMN "pig"."gen_table"."ds_name" IS '数据源ID';
COMMENT ON COLUMN "pig"."gen_table"."baseclass_id" IS '基类ID';
COMMENT ON COLUMN "pig"."gen_table"."create_time" IS '创建时间';
COMMENT ON TABLE "pig"."gen_table" IS '代码生成表';

-- ----------------------------
-- Records of gen_table
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for gen_table_column
-- ----------------------------
DROP TABLE IF EXISTS "pig"."gen_table_column";
CREATE TABLE "pig"."gen_table_column" (
  "id" int8 NOT NULL,
  "ds_name" varchar(200) COLLATE "pg_catalog"."default",
  "table_name" varchar(200) COLLATE "pg_catalog"."default",
  "field_name" varchar(200) COLLATE "pg_catalog"."default",
  "field_type" varchar(200) COLLATE "pg_catalog"."default",
  "field_comment" varchar(200) COLLATE "pg_catalog"."default",
  "attr_name" varchar(200) COLLATE "pg_catalog"."default",
  "attr_type" varchar(200) COLLATE "pg_catalog"."default",
  "package_name" varchar(200) COLLATE "pg_catalog"."default",
  "sort" int4,
  "auto_fill" varchar(20) COLLATE "pg_catalog"."default",
  "primary_pk" char(1) COLLATE "pg_catalog"."default",
  "base_field" char(1) COLLATE "pg_catalog"."default",
  "form_item" char(1) COLLATE "pg_catalog"."default",
  "form_required" char(1) COLLATE "pg_catalog"."default",
  "form_type" varchar(200) COLLATE "pg_catalog"."default",
  "form_validator" varchar(200) COLLATE "pg_catalog"."default",
  "grid_item" char(1) COLLATE "pg_catalog"."default",
  "grid_sort" char(1) COLLATE "pg_catalog"."default",
  "query_item" char(1) COLLATE "pg_catalog"."default",
  "query_type" varchar(200) COLLATE "pg_catalog"."default",
  "query_form_type" varchar(200) COLLATE "pg_catalog"."default",
  "field_dict" varchar(200) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "pig"."gen_table_column" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."gen_table_column"."ds_name" IS '数据源名称';
COMMENT ON COLUMN "pig"."gen_table_column"."table_name" IS '表名称';
COMMENT ON COLUMN "pig"."gen_table_column"."field_name" IS '字段名称';
COMMENT ON COLUMN "pig"."gen_table_column"."field_type" IS '字段类型';
COMMENT ON COLUMN "pig"."gen_table_column"."field_comment" IS '字段说明';
COMMENT ON COLUMN "pig"."gen_table_column"."attr_name" IS '属性名';
COMMENT ON COLUMN "pig"."gen_table_column"."attr_type" IS '属性类型';
COMMENT ON COLUMN "pig"."gen_table_column"."package_name" IS '属性包名';
COMMENT ON COLUMN "pig"."gen_table_column"."sort" IS '排序';
COMMENT ON COLUMN "pig"."gen_table_column"."auto_fill" IS '自动填充  DEFAULT、INSERT、UPDATE、INSERT_UPDATE';
COMMENT ON COLUMN "pig"."gen_table_column"."primary_pk" IS '主键 0：否  1：是';
COMMENT ON COLUMN "pig"."gen_table_column"."base_field" IS '基类字段 0：否  1：是';
COMMENT ON COLUMN "pig"."gen_table_column"."form_item" IS '表单项 0：否  1：是';
COMMENT ON COLUMN "pig"."gen_table_column"."form_required" IS '表单必填 0：否  1：是';
COMMENT ON COLUMN "pig"."gen_table_column"."form_type" IS '表单类型';
COMMENT ON COLUMN "pig"."gen_table_column"."form_validator" IS '表单效验';
COMMENT ON COLUMN "pig"."gen_table_column"."grid_item" IS '列表项 0：否  1：是';
COMMENT ON COLUMN "pig"."gen_table_column"."grid_sort" IS '列表排序 0：否  1：是';
COMMENT ON COLUMN "pig"."gen_table_column"."query_item" IS '查询项 0：否  1：是';
COMMENT ON COLUMN "pig"."gen_table_column"."query_type" IS '查询方式';
COMMENT ON COLUMN "pig"."gen_table_column"."query_form_type" IS '查询表单类型';
COMMENT ON COLUMN "pig"."gen_table_column"."field_dict" IS '字典类型';
COMMENT ON TABLE "pig"."gen_table_column" IS '代码生成表字段';

-- ----------------------------
-- Records of gen_table_column
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for gen_template
-- ----------------------------
DROP TABLE IF EXISTS "pig"."gen_template";
CREATE TABLE "pig"."gen_template" (
  "id" int8 NOT NULL,
  "template_name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "generator_path" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "template_desc" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "template_code" text COLLATE "pg_catalog"."default" NOT NULL,
  "create_time" timestamp(6),
  "update_time" timestamp(6),
  "del_flag" char(1) COLLATE "pg_catalog"."default" NOT NULL,
  "create_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "update_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL
)
;
ALTER TABLE "pig"."gen_template" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."gen_template"."id" IS '主键';
COMMENT ON COLUMN "pig"."gen_template"."template_name" IS '模板名称';
COMMENT ON COLUMN "pig"."gen_template"."generator_path" IS '模板路径';
COMMENT ON COLUMN "pig"."gen_template"."template_desc" IS '模板描述';
COMMENT ON COLUMN "pig"."gen_template"."template_code" IS '模板代码';
COMMENT ON COLUMN "pig"."gen_template"."create_time" IS '创建时间';
COMMENT ON COLUMN "pig"."gen_template"."update_time" IS '更新';
COMMENT ON COLUMN "pig"."gen_template"."del_flag" IS '删除标记';
COMMENT ON COLUMN "pig"."gen_template"."create_by" IS '创建人';
COMMENT ON COLUMN "pig"."gen_template"."update_by" IS '修改人';
COMMENT ON TABLE "pig"."gen_template" IS '模板';

-- ----------------------------
-- Records of gen_template
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for gen_template_group
-- ----------------------------
DROP TABLE IF EXISTS "pig"."gen_template_group";
CREATE TABLE "pig"."gen_template_group" (
  "group_id" int8 NOT NULL,
  "template_id" int8 NOT NULL
)
;
ALTER TABLE "pig"."gen_template_group" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."gen_template_group"."group_id" IS '分组id';
COMMENT ON COLUMN "pig"."gen_template_group"."template_id" IS '模板id';
COMMENT ON TABLE "pig"."gen_template_group" IS '模板分组关联表';

-- ----------------------------
-- Records of gen_template_group
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS "pig"."sys_dept";
CREATE TABLE "pig"."sys_dept" (
  "dept_id" int8 NOT NULL,
  "name" varchar(50) COLLATE "pg_catalog"."default",
  "sort_order" int4 NOT NULL,
  "create_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "update_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "create_time" timestamp(6),
  "update_time" timestamp(6),
  "del_flag" char(1) COLLATE "pg_catalog"."default",
  "parent_id" int8
)
;
ALTER TABLE "pig"."sys_dept" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."sys_dept"."dept_id" IS '部门ID';
COMMENT ON COLUMN "pig"."sys_dept"."name" IS '部门名称';
COMMENT ON COLUMN "pig"."sys_dept"."sort_order" IS '排序';
COMMENT ON COLUMN "pig"."sys_dept"."create_by" IS '创建人';
COMMENT ON COLUMN "pig"."sys_dept"."update_by" IS '修改人';
COMMENT ON COLUMN "pig"."sys_dept"."create_time" IS '创建时间';
COMMENT ON COLUMN "pig"."sys_dept"."update_time" IS '修改时间';
COMMENT ON COLUMN "pig"."sys_dept"."del_flag" IS '删除标志';
COMMENT ON COLUMN "pig"."sys_dept"."parent_id" IS '父级部门ID';
COMMENT ON TABLE "pig"."sys_dept" IS '部门管理';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO "pig"."sys_dept" ("dept_id", "name", "sort_order", "create_by", "update_by", "create_time", "update_time", "del_flag", "parent_id") VALUES (1, '总裁办', 1, 'admin', 'admin', '2023-04-03 13:04:47', '2023-04-03 13:07:49', '0', 0);
INSERT INTO "pig"."sys_dept" ("dept_id", "name", "sort_order", "create_by", "update_by", "create_time", "update_time", "del_flag", "parent_id") VALUES (2, '技术部', 2, 'admin', 'admin', '2023-04-03 13:04:47', '2023-04-03 13:04:47', '0', 1);
INSERT INTO "pig"."sys_dept" ("dept_id", "name", "sort_order", "create_by", "update_by", "create_time", "update_time", "del_flag", "parent_id") VALUES (3, '市场部', 3, 'admin', 'admin', '2023-04-03 13:04:47', '2023-04-03 13:04:47', '0', 1);
INSERT INTO "pig"."sys_dept" ("dept_id", "name", "sort_order", "create_by", "update_by", "create_time", "update_time", "del_flag", "parent_id") VALUES (4, '销售部', 4, 'admin', 'admin', '2023-04-03 13:04:47', '2023-04-03 13:04:47', '0', 1);
INSERT INTO "pig"."sys_dept" ("dept_id", "name", "sort_order", "create_by", "update_by", "create_time", "update_time", "del_flag", "parent_id") VALUES (5, '财务部', 5, 'admin', 'admin', '2023-04-03 13:04:47', '2023-04-03 13:04:47', '0', 1);
INSERT INTO "pig"."sys_dept" ("dept_id", "name", "sort_order", "create_by", "update_by", "create_time", "update_time", "del_flag", "parent_id") VALUES (6, '人事行政部', 6, 'admin', 'admin', '2023-04-03 13:04:47', '2023-04-03 13:53:36', '1', 1);
INSERT INTO "pig"."sys_dept" ("dept_id", "name", "sort_order", "create_by", "update_by", "create_time", "update_time", "del_flag", "parent_id") VALUES (7, '研发部', 7, 'admin', 'admin', '2023-04-03 13:04:47', '2023-04-03 13:04:47', '0', 2);
INSERT INTO "pig"."sys_dept" ("dept_id", "name", "sort_order", "create_by", "update_by", "create_time", "update_time", "del_flag", "parent_id") VALUES (8, 'UI设计部', 11, 'admin', 'admin', '2023-04-03 13:04:47', '2023-04-03 13:04:47', '0', 7);
INSERT INTO "pig"."sys_dept" ("dept_id", "name", "sort_order", "create_by", "update_by", "create_time", "update_time", "del_flag", "parent_id") VALUES (9, '产品部', 12, 'admin', 'admin', '2023-04-03 13:04:47', '2023-04-03 13:04:47', '0', 2);
INSERT INTO "pig"."sys_dept" ("dept_id", "name", "sort_order", "create_by", "update_by", "create_time", "update_time", "del_flag", "parent_id") VALUES (10, '渠道部', 13, 'admin', 'admin', '2023-04-03 13:04:47', '2023-04-03 13:04:47', '0', 3);
INSERT INTO "pig"."sys_dept" ("dept_id", "name", "sort_order", "create_by", "update_by", "create_time", "update_time", "del_flag", "parent_id") VALUES (11, '推广部', 14, 'admin', 'admin', '2023-04-03 13:04:47', '2023-04-03 13:04:47', '0', 3);
INSERT INTO "pig"."sys_dept" ("dept_id", "name", "sort_order", "create_by", "update_by", "create_time", "update_time", "del_flag", "parent_id") VALUES (12, '客服部', 15, 'admin', 'admin', '2023-04-03 13:04:47', '2023-04-03 13:04:47', '0', 4);
INSERT INTO "pig"."sys_dept" ("dept_id", "name", "sort_order", "create_by", "update_by", "create_time", "update_time", "del_flag", "parent_id") VALUES (13, '财务会计部', 16, 'admin', 'admin', '2023-04-03 13:04:47', '2023-04-03 13:04:47', '0', 5);
INSERT INTO "pig"."sys_dept" ("dept_id", "name", "sort_order", "create_by", "update_by", "create_time", "update_time", "del_flag", "parent_id") VALUES (14, '审计风控部', 17, 'admin', 'admin', '2023-04-03 13:04:47', '2023-04-03 14:06:57', '0', 5);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS "pig"."sys_dict";
CREATE TABLE "pig"."sys_dict" (
  "id" int8 NOT NULL,
  "dict_type" varchar(100) COLLATE "pg_catalog"."default",
  "description" varchar(100) COLLATE "pg_catalog"."default",
  "create_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "update_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "create_time" timestamp(6),
  "update_time" timestamp(6),
  "remarks" varchar(255) COLLATE "pg_catalog"."default",
  "system_flag" char(1) COLLATE "pg_catalog"."default",
  "del_flag" char(1) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "pig"."sys_dict" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."sys_dict"."id" IS '编号';
COMMENT ON COLUMN "pig"."sys_dict"."dict_type" IS '字典类型';
COMMENT ON COLUMN "pig"."sys_dict"."description" IS '描述';
COMMENT ON COLUMN "pig"."sys_dict"."create_by" IS '创建人';
COMMENT ON COLUMN "pig"."sys_dict"."update_by" IS '修改人';
COMMENT ON COLUMN "pig"."sys_dict"."create_time" IS '创建时间';
COMMENT ON COLUMN "pig"."sys_dict"."update_time" IS '更新时间';
COMMENT ON COLUMN "pig"."sys_dict"."remarks" IS '备注信息';
COMMENT ON COLUMN "pig"."sys_dict"."system_flag" IS '系统标志';
COMMENT ON COLUMN "pig"."sys_dict"."del_flag" IS '删除标志';
COMMENT ON TABLE "pig"."sys_dict" IS '字典表';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (1, 'log_type', '日志类型', ' ', ' ', '2019-03-19 11:06:44', '2019-03-19 11:06:44', '异常、正常', '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (2, 'social_type', '社交登录', ' ', ' ', '2019-03-19 11:09:44', '2019-03-19 11:09:44', '微信、QQ', '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (3, 'job_type', '定时任务类型', ' ', ' ', '2019-03-19 11:22:21', '2019-03-19 11:22:21', 'quartz', '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (4, 'job_status', '定时任务状态', ' ', ' ', '2019-03-19 11:24:57', '2019-03-19 11:24:57', '发布状态、运行状态', '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (5, 'job_execute_status', '定时任务执行状态', ' ', ' ', '2019-03-19 11:26:15', '2019-03-19 11:26:15', '正常、异常', '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (6, 'misfire_policy', '定时任务错失执行策略', ' ', ' ', '2019-03-19 11:27:19', '2019-03-19 11:27:19', '周期', '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (7, 'gender', '性别', ' ', ' ', '2019-03-27 13:44:06', '2019-03-27 13:44:06', '微信用户性别', '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (8, 'subscribe', '订阅状态', ' ', ' ', '2019-03-27 13:48:33', '2019-03-27 13:48:33', '公众号订阅状态', '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (9, 'response_type', '回复', ' ', ' ', '2019-03-28 21:29:21', '2019-03-28 21:29:21', '微信消息是否已回复', '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (10, 'param_type', '参数配置', ' ', ' ', '2019-04-29 18:20:47', '2019-04-29 18:20:47', '检索、原文、报表、安全、文档、消息、其他', '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (11, 'status_type', '租户状态', ' ', ' ', '2019-05-15 16:31:08', '2019-05-15 16:31:08', '租户状态', '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (12, 'dict_type', '字典类型', ' ', ' ', '2019-05-16 14:16:20', '2019-05-16 14:20:16', '系统类不能修改', '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (13, 'channel_type', '支付类型', ' ', ' ', '2019-05-16 14:16:20', '2019-05-16 14:20:16', '系统类不能修改', '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (14, 'grant_types', '授权类型', ' ', ' ', '2019-08-13 07:34:10', '2019-08-13 07:34:10', NULL, '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (15, 'style_type', '前端风格', ' ', ' ', '2020-02-07 03:49:28', '2020-02-07 03:50:40', '0-Avue 1-element', '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (16, 'captcha_flag_types', '验证码开关', ' ', ' ', '2020-11-18 06:53:25', '2020-11-18 06:53:25', '是否校验验证码', '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (17, 'enc_flag_types', '前端密码加密', ' ', ' ', '2020-11-18 06:54:44', '2020-11-18 06:54:44', '前端密码是否加密传输', '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (18, 'lock_flag', '用户状态', 'admin', ' ', '2023-02-01 16:55:31', NULL, NULL, '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (19, 'ds_config_type', '数据连接类型', 'admin', ' ', '2023-02-06 18:36:59', NULL, NULL, '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (20, 'common_status', '通用状态', 'admin', ' ', '2023-02-09 11:02:08', NULL, NULL, '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (21, 'app_social_type', 'app社交登录', 'admin', ' ', '2023-02-10 11:11:06', NULL, 'app社交登录', '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (22, 'yes_no_type', '是否', 'admin', ' ', '2023-02-20 23:25:04', NULL, NULL, '1', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (23, 'repType', '微信消息类型', 'admin', ' ', '2023-02-24 15:08:25', NULL, NULL, '0', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (24, 'leave_status', '请假状态', 'admin', ' ', '2023-03-02 22:50:15', NULL, NULL, '0', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (25, 'schedule_type', '日程类型', 'admin', ' ', '2023-03-06 14:49:18', NULL, NULL, '0', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (26, 'schedule_status', '日程状态', 'admin', ' ', '2023-03-06 14:52:57', NULL, NULL, '0', '0');
INSERT INTO "pig"."sys_dict" ("id", "dict_type", "description", "create_by", "update_by", "create_time", "update_time", "remarks", "system_flag", "del_flag") VALUES (27, 'ds_type', '代码生成器支持的数据库类型', 'admin', ' ', '2023-03-12 09:57:59', NULL, NULL, '1', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_item
-- ----------------------------
DROP TABLE IF EXISTS "pig"."sys_dict_item";
CREATE TABLE "pig"."sys_dict_item" (
  "id" int8 NOT NULL,
  "dict_id" int8 NOT NULL,
  "item_value" varchar(100) COLLATE "pg_catalog"."default",
  "label" varchar(100) COLLATE "pg_catalog"."default",
  "dict_type" varchar(100) COLLATE "pg_catalog"."default",
  "description" varchar(100) COLLATE "pg_catalog"."default",
  "sort_order" int4 NOT NULL,
  "create_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "update_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "create_time" timestamp(6),
  "update_time" timestamp(6),
  "remarks" varchar(255) COLLATE "pg_catalog"."default",
  "del_flag" char(1) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "pig"."sys_dict_item" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."sys_dict_item"."id" IS '编号';
COMMENT ON COLUMN "pig"."sys_dict_item"."dict_id" IS '字典ID';
COMMENT ON COLUMN "pig"."sys_dict_item"."item_value" IS '字典项值';
COMMENT ON COLUMN "pig"."sys_dict_item"."label" IS '字典项名称';
COMMENT ON COLUMN "pig"."sys_dict_item"."dict_type" IS '字典类型';
COMMENT ON COLUMN "pig"."sys_dict_item"."description" IS '字典项描述';
COMMENT ON COLUMN "pig"."sys_dict_item"."sort_order" IS '排序（升序）';
COMMENT ON COLUMN "pig"."sys_dict_item"."create_by" IS '创建人';
COMMENT ON COLUMN "pig"."sys_dict_item"."update_by" IS '修改人';
COMMENT ON COLUMN "pig"."sys_dict_item"."create_time" IS '创建时间';
COMMENT ON COLUMN "pig"."sys_dict_item"."update_time" IS '更新时间';
COMMENT ON COLUMN "pig"."sys_dict_item"."remarks" IS '备注信息';
COMMENT ON COLUMN "pig"."sys_dict_item"."del_flag" IS '删除标志';
COMMENT ON TABLE "pig"."sys_dict_item" IS '字典项';

-- ----------------------------
-- Records of sys_dict_item
-- ----------------------------
BEGIN;
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (1, 1, '9', '异常', 'log_type', '日志异常', 1, ' ', ' ', '2019-03-19 11:08:59', '2019-03-25 12:49:13', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (2, 1, '0', '正常', 'log_type', '日志正常', 0, ' ', ' ', '2019-03-19 11:09:17', '2019-03-25 12:49:18', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (3, 2, 'WX', '微信', 'social_type', '微信登录', 0, ' ', ' ', '2019-03-19 11:10:02', '2019-03-25 12:49:36', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (4, 2, 'QQ', 'QQ', 'social_type', 'QQ登录', 1, ' ', ' ', '2019-03-19 11:10:14', '2019-03-25 12:49:36', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (5, 3, '1', 'java类', 'job_type', 'java类', 1, ' ', ' ', '2019-03-19 11:22:37', '2019-03-25 12:49:36', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (6, 3, '2', 'spring bean', 'job_type', 'spring bean容器实例', 2, ' ', ' ', '2019-03-19 11:23:05', '2019-03-25 12:49:36', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (7, 3, '9', '其他', 'job_type', '其他类型', 9, ' ', ' ', '2019-03-19 11:23:31', '2019-03-25 12:49:36', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (8, 3, '3', 'Rest 调用', 'job_type', 'Rest 调用', 3, ' ', ' ', '2019-03-19 11:23:57', '2019-03-25 12:49:36', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (9, 3, '4', 'jar', 'job_type', 'jar类型', 4, ' ', ' ', '2019-03-19 11:24:20', '2019-03-25 12:49:36', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (10, 4, '1', '未发布', 'job_status', '未发布', 1, ' ', ' ', '2019-03-19 11:25:18', '2019-03-25 12:49:36', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (11, 4, '2', '运行中', 'job_status', '运行中', 2, ' ', ' ', '2019-03-19 11:25:31', '2019-03-25 12:49:36', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (12, 4, '3', '暂停', 'job_status', '暂停', 3, ' ', ' ', '2019-03-19 11:25:42', '2019-03-25 12:49:36', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (13, 5, '0', '正常', 'job_execute_status', '正常', 0, ' ', ' ', '2019-03-19 11:26:27', '2019-03-25 12:49:36', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (14, 5, '1', '异常', 'job_execute_status', '异常', 1, ' ', ' ', '2019-03-19 11:26:41', '2019-03-25 12:49:36', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (15, 6, '1', '错失周期立即执行', 'misfire_policy', '错失周期立即执行', 1, ' ', ' ', '2019-03-19 11:27:45', '2019-03-25 12:49:36', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (16, 6, '2', '错失周期执行一次', 'misfire_policy', '错失周期执行一次', 2, ' ', ' ', '2019-03-19 11:27:57', '2019-03-25 12:49:36', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (17, 6, '3', '下周期执行', 'misfire_policy', '下周期执行', 3, ' ', ' ', '2019-03-19 11:28:08', '2019-03-25 12:49:36', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (18, 7, '1', '男', 'gender', '微信-男', 0, ' ', ' ', '2019-03-27 13:45:13', '2019-03-27 13:45:13', '微信-男', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (19, 7, '2', '女', 'gender', '女-微信', 1, ' ', ' ', '2019-03-27 13:45:34', '2019-03-27 13:45:34', '女-微信', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (20, 7, '0', '未知', 'gender', 'x性别未知', 3, ' ', ' ', '2019-03-27 13:45:57', '2019-03-27 13:45:57', 'x性别未知', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (21, 8, '0', '未关注', 'subscribe', '公众号-未关注', 0, ' ', ' ', '2019-03-27 13:49:07', '2019-03-27 13:49:07', '公众号-未关注', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (22, 8, '1', '已关注', 'subscribe', '公众号-已关注', 1, ' ', ' ', '2019-03-27 13:49:26', '2019-03-27 13:49:26', '公众号-已关注', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (23, 9, '0', '未回复', 'response_type', '微信消息-未回复', 0, ' ', ' ', '2019-03-28 21:29:47', '2019-03-28 21:29:47', '微信消息-未回复', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (24, 9, '1', '已回复', 'response_type', '微信消息-已回复', 1, ' ', ' ', '2019-03-28 21:30:08', '2019-03-28 21:30:08', '微信消息-已回复', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (25, 10, '1', '检索', 'param_type', '检索', 0, ' ', ' ', '2019-04-29 18:22:17', '2019-04-29 18:22:17', '检索', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (26, 10, '2', '原文', 'param_type', '原文', 0, ' ', ' ', '2019-04-29 18:22:27', '2019-04-29 18:22:27', '原文', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (27, 10, '3', '报表', 'param_type', '报表', 0, ' ', ' ', '2019-04-29 18:22:36', '2019-04-29 18:22:36', '报表', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (28, 10, '4', '安全', 'param_type', '安全', 0, ' ', ' ', '2019-04-29 18:22:46', '2019-04-29 18:22:46', '安全', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (29, 10, '5', '文档', 'param_type', '文档', 0, ' ', ' ', '2019-04-29 18:22:56', '2019-04-29 18:22:56', '文档', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (30, 10, '6', '消息', 'param_type', '消息', 0, ' ', ' ', '2019-04-29 18:23:05', '2019-04-29 18:23:05', '消息', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (31, 10, '9', '其他', 'param_type', '其他', 0, ' ', ' ', '2019-04-29 18:23:16', '2019-04-29 18:23:16', '其他', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (32, 10, '0', '默认', 'param_type', '默认', 0, ' ', ' ', '2019-04-29 18:23:30', '2019-04-29 18:23:30', '默认', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (33, 11, '0', '正常', 'status_type', '状态正常', 0, ' ', ' ', '2019-05-15 16:31:34', '2019-05-16 22:30:46', '状态正常', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (34, 11, '9', '冻结', 'status_type', '状态冻结', 1, ' ', ' ', '2019-05-15 16:31:56', '2019-05-16 22:30:50', '状态冻结', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (35, 12, '1', '系统类', 'dict_type', '系统类字典', 0, ' ', ' ', '2019-05-16 14:20:40', '2019-05-16 14:20:40', '不能修改删除', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (36, 12, '0', '业务类', 'dict_type', '业务类字典', 0, ' ', ' ', '2019-05-16 14:20:59', '2019-05-16 14:20:59', '可以修改', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (37, 2, 'GITEE', '码云', 'social_type', '码云', 2, ' ', ' ', '2019-06-28 09:59:12', '2019-06-28 09:59:12', '码云', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (38, 2, 'OSC', '开源中国', 'social_type', '开源中国登录', 2, ' ', ' ', '2019-06-28 10:04:32', '2019-06-28 10:04:32', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (39, 14, 'password', '密码模式', 'grant_types', '支持oauth密码模式', 0, ' ', ' ', '2019-08-13 07:35:28', '2019-08-13 07:35:28', NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (40, 14, 'authorization_code', '授权码模式', 'grant_types', 'oauth2 授权码模式', 1, ' ', ' ', '2019-08-13 07:36:07', '2019-08-13 07:36:07', NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (41, 14, 'client_credentials', '客户端模式', 'grant_types', 'oauth2 客户端模式', 2, ' ', ' ', '2019-08-13 07:36:30', '2019-08-13 07:36:30', NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (42, 14, 'refresh_token', '刷新模式', 'grant_types', 'oauth2 刷新token', 3, ' ', ' ', '2019-08-13 07:36:54', '2019-08-13 07:36:54', NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (43, 14, 'implicit', '简化模式', 'grant_types', 'oauth2 简化模式', 4, ' ', ' ', '2019-08-13 07:39:32', '2019-08-13 07:39:32', NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (44, 15, '0', 'Avue', 'style_type', 'Avue风格', 0, ' ', ' ', '2020-02-07 03:52:52', '2020-02-07 03:52:52', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (45, 15, '1', 'element', 'style_type', 'element-ui', 1, ' ', ' ', '2020-02-07 03:53:12', '2020-02-07 03:53:12', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (46, 16, '0', '关', 'captcha_flag_types', '不校验验证码', 0, ' ', ' ', '2020-11-18 06:53:58', '2020-11-18 06:53:58', '不校验验证码 -0', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (47, 16, '1', '开', 'captcha_flag_types', '校验验证码', 1, ' ', ' ', '2020-11-18 06:54:15', '2020-11-18 06:54:15', '不校验验证码-1', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (48, 17, '0', '否', 'enc_flag_types', '不加密', 0, ' ', ' ', '2020-11-18 06:55:31', '2020-11-18 06:55:31', '不加密-0', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (49, 17, '1', '是', 'enc_flag_types', '加密', 1, ' ', ' ', '2020-11-18 06:55:51', '2020-11-18 06:55:51', '加密-1', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (50, 13, 'MERGE_PAY', '聚合支付', 'channel_type', '聚合支付', 1, ' ', ' ', '2019-05-30 19:08:08', '2019-06-18 13:51:53', '聚合支付', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (51, 2, 'CAS', 'CAS登录', 'social_type', 'CAS 单点登录系统', 3, ' ', ' ', '2022-02-18 13:56:25', '2022-02-18 13:56:28', NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (52, 2, 'DINGTALK', '钉钉', 'social_type', '钉钉', 3, ' ', ' ', '2022-02-18 13:56:25', '2022-02-18 13:56:28', NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (53, 2, 'WEIXIN_CP', '企业微信', 'social_type', '企业微信', 3, ' ', ' ', '2022-02-18 13:56:25', '2022-02-18 13:56:28', NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (54, 15, '2', 'APP', 'style_type', 'uview风格', 1, ' ', ' ', '2020-02-07 03:53:12', '2020-02-07 03:53:12', '', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (55, 13, 'ALIPAY_WAP', '支付宝支付', 'channel_type', '支付宝支付', 1, ' ', ' ', '2019-05-30 19:08:08', '2019-06-18 13:51:53', '聚合支付', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (56, 13, 'WEIXIN_MP', '微信支付', 'channel_type', '微信支付', 1, ' ', ' ', '2019-05-30 19:08:08', '2019-06-18 13:51:53', '聚合支付', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (57, 14, 'mobile', 'mobile', 'grant_types', '移动端登录', 5, 'admin', ' ', '2023-01-29 17:21:42', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (58, 18, '0', '有效', 'lock_flag', '有效', 0, 'admin', ' ', '2023-02-01 16:56:00', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (59, 18, '9', '禁用', 'lock_flag', '禁用', 1, 'admin', ' ', '2023-02-01 16:56:09', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (60, 15, '4', 'vue3', 'style_type', 'element-plus', 4, 'admin', ' ', '2023-02-06 13:52:43', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (61, 19, '0', '主机', 'ds_config_type', '主机', 0, 'admin', ' ', '2023-02-06 18:37:23', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (62, 19, '1', 'JDBC', 'ds_config_type', 'jdbc', 2, 'admin', ' ', '2023-02-06 18:37:34', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (63, 20, 'false', '否', 'common_status', '否', 1, 'admin', ' ', '2023-02-09 11:02:39', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (64, 20, 'true', '是', 'common_status', '是', 2, 'admin', ' ', '2023-02-09 11:02:52', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (65, 21, 'MINI', '小程序', 'app_social_type', '小程序登录', 0, 'admin', ' ', '2023-02-10 11:11:41', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (66, 22, '0', '否', 'yes_no_type', '0', 0, 'admin', ' ', '2023-02-20 23:35:23', NULL, '0', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (67, 22, '1', '是', 'yes_no_type', '1', 0, 'admin', ' ', '2023-02-20 23:35:37', NULL, '1', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (69, 23, 'text', '文本', 'repType', '文本', 0, 'admin', ' ', '2023-02-24 15:08:45', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (70, 23, 'image', '图片', 'repType', '图片', 0, 'admin', ' ', '2023-02-24 15:08:56', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (71, 23, 'voice', '语音', 'repType', '语音', 0, 'admin', ' ', '2023-02-24 15:09:08', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (72, 23, 'video', '视频', 'repType', '视频', 0, 'admin', ' ', '2023-02-24 15:09:18', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (73, 23, 'shortvideo', '小视频', 'repType', '小视频', 0, 'admin', ' ', '2023-02-24 15:09:29', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (74, 23, 'location', '地理位置', 'repType', '地理位置', 0, 'admin', ' ', '2023-02-24 15:09:41', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (75, 23, 'link', '链接消息', 'repType', '链接消息', 0, 'admin', ' ', '2023-02-24 15:09:49', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (76, 23, 'event', '事件推送', 'repType', '事件推送', 0, 'admin', ' ', '2023-02-24 15:09:57', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (77, 24, '0', '未提交', 'leave_status', '未提交', 0, 'admin', ' ', '2023-03-02 22:50:45', NULL, '未提交', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (78, 24, '1', '审批中', 'leave_status', '审批中', 0, 'admin', ' ', '2023-03-02 22:50:57', NULL, '审批中', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (79, 24, '2', '完成', 'leave_status', '完成', 0, 'admin', ' ', '2023-03-02 22:51:06', NULL, '完成', '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (80, 24, '9', '驳回', 'leave_status', '驳回', 0, 'admin', ' ', '2023-03-02 22:51:20', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (81, 25, 'record', '日程记录', 'schedule_type', '日程记录', 0, 'admin', ' ', '2023-03-06 14:50:01', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (82, 25, 'plan', '计划', 'schedule_type', '计划类型', 0, 'admin', ' ', '2023-03-06 14:50:29', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (83, 26, '0', '计划中', 'schedule_status', '日程状态', 0, 'admin', ' ', '2023-03-06 14:53:18', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (84, 26, '1', '已开始', 'schedule_status', '已开始', 0, 'admin', ' ', '2023-03-06 14:53:33', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (85, 26, '3', '已结束', 'schedule_status', '已结束', 0, 'admin', ' ', '2023-03-06 14:53:41', NULL, NULL, '0');
INSERT INTO "pig"."sys_dict_item" ("id", "dict_id", "item_value", "label", "dict_type", "description", "sort_order", "create_by", "update_by", "create_time", "update_time", "remarks", "del_flag") VALUES (86, 27, 'mysql', 'mysql', 'ds_type', 'mysql', 0, 'admin', ' ', '2023-03-12 09:58:11', NULL, NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_file
-- ----------------------------
DROP TABLE IF EXISTS "pig"."sys_file";
CREATE TABLE "pig"."sys_file" (
  "id" int8 NOT NULL,
  "file_name" varchar(100) COLLATE "pg_catalog"."default",
  "bucket_name" varchar(200) COLLATE "pg_catalog"."default",
  "original" varchar(100) COLLATE "pg_catalog"."default",
  "type" varchar(50) COLLATE "pg_catalog"."default",
  "file_size" int8,
  "create_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "update_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "create_time" timestamp(6),
  "update_time" timestamp(6),
  "del_flag" char(1) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "pig"."sys_file" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."sys_file"."id" IS '编号';
COMMENT ON COLUMN "pig"."sys_file"."file_name" IS '文件名';
COMMENT ON COLUMN "pig"."sys_file"."bucket_name" IS '文件存储桶名称';
COMMENT ON COLUMN "pig"."sys_file"."original" IS '原始文件名';
COMMENT ON COLUMN "pig"."sys_file"."type" IS '文件类型';
COMMENT ON COLUMN "pig"."sys_file"."file_size" IS '文件大小';
COMMENT ON COLUMN "pig"."sys_file"."create_by" IS '创建人';
COMMENT ON COLUMN "pig"."sys_file"."update_by" IS '修改人';
COMMENT ON COLUMN "pig"."sys_file"."create_time" IS '上传时间';
COMMENT ON COLUMN "pig"."sys_file"."update_time" IS '更新时间';
COMMENT ON COLUMN "pig"."sys_file"."del_flag" IS '删除标志';
COMMENT ON TABLE "pig"."sys_file" IS '文件管理表';

-- ----------------------------
-- Records of sys_file
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS "pig"."sys_job";
CREATE TABLE "pig"."sys_job" (
  "job_id" int8 NOT NULL,
  "job_name" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "job_group" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "job_order" char(1) COLLATE "pg_catalog"."default",
  "job_type" char(1) COLLATE "pg_catalog"."default" NOT NULL,
  "execute_path" varchar(500) COLLATE "pg_catalog"."default",
  "class_name" varchar(500) COLLATE "pg_catalog"."default",
  "method_name" varchar(500) COLLATE "pg_catalog"."default",
  "method_params_value" varchar(2000) COLLATE "pg_catalog"."default",
  "cron_expression" varchar(255) COLLATE "pg_catalog"."default",
  "misfire_policy" varchar(20) COLLATE "pg_catalog"."default",
  "job_tenant_type" char(1) COLLATE "pg_catalog"."default",
  "job_status" char(1) COLLATE "pg_catalog"."default",
  "job_execute_status" char(1) COLLATE "pg_catalog"."default",
  "create_by" varchar(64) COLLATE "pg_catalog"."default",
  "create_time" timestamp(6) NOT NULL,
  "update_by" varchar(64) COLLATE "pg_catalog"."default",
  "update_time" timestamp(6) NOT NULL,
  "start_time" timestamp(6),
  "previous_time" timestamp(6),
  "next_time" timestamp(6),
  "remark" varchar(500) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "pig"."sys_job" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."sys_job"."job_id" IS '任务id';
COMMENT ON COLUMN "pig"."sys_job"."job_name" IS '任务名称';
COMMENT ON COLUMN "pig"."sys_job"."job_group" IS '任务组名';
COMMENT ON COLUMN "pig"."sys_job"."job_order" IS '组内执行顺利，值越大执行优先级越高，最大值9，最小值1';
COMMENT ON COLUMN "pig"."sys_job"."job_type" IS '1、java类;2、spring bean名称;3、rest调用;4、jar调用;9其他';
COMMENT ON COLUMN "pig"."sys_job"."execute_path" IS 'job_type=3时，rest调用地址，仅支持rest get协议,需要增加String返回值，0成功，1失败;job_type=4时，jar路径;其它值为空';
COMMENT ON COLUMN "pig"."sys_job"."class_name" IS 'job_type=1时，类完整路径;job_type=2时，spring bean名称;其它值为空';
COMMENT ON COLUMN "pig"."sys_job"."method_name" IS '任务方法';
COMMENT ON COLUMN "pig"."sys_job"."method_params_value" IS '参数值';
COMMENT ON COLUMN "pig"."sys_job"."cron_expression" IS 'cron执行表达式';
COMMENT ON COLUMN "pig"."sys_job"."misfire_policy" IS '错失执行策略（1错失周期立即执行 2错失周期执行一次 3下周期执行）';
COMMENT ON COLUMN "pig"."sys_job"."job_tenant_type" IS '1、多租户任务;2、非多租户任务';
COMMENT ON COLUMN "pig"."sys_job"."job_status" IS '状态（1、未发布;2、运行中;3、暂停;4、删除;）';
COMMENT ON COLUMN "pig"."sys_job"."job_execute_status" IS '状态（0正常 1异常）';
COMMENT ON COLUMN "pig"."sys_job"."create_by" IS '创建者';
COMMENT ON COLUMN "pig"."sys_job"."create_time" IS '创建时间';
COMMENT ON COLUMN "pig"."sys_job"."update_by" IS '更新者';
COMMENT ON COLUMN "pig"."sys_job"."update_time" IS '更新时间';
COMMENT ON COLUMN "pig"."sys_job"."start_time" IS '初次执行时间';
COMMENT ON COLUMN "pig"."sys_job"."previous_time" IS '上次执行时间';
COMMENT ON COLUMN "pig"."sys_job"."next_time" IS '下次执行时间';
COMMENT ON COLUMN "pig"."sys_job"."remark" IS '备注信息';
COMMENT ON TABLE "pig"."sys_job" IS '定时任务调度表';

-- ----------------------------
-- Records of sys_job
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_job_log
-- ----------------------------
DROP TABLE IF EXISTS "pig"."sys_job_log";
CREATE TABLE "pig"."sys_job_log" (
  "job_log_id" int8 NOT NULL,
  "job_id" int8 NOT NULL,
  "job_name" varchar(64) COLLATE "pg_catalog"."default",
  "job_group" varchar(64) COLLATE "pg_catalog"."default",
  "job_order" char(1) COLLATE "pg_catalog"."default",
  "job_type" char(1) COLLATE "pg_catalog"."default" NOT NULL,
  "execute_path" varchar(500) COLLATE "pg_catalog"."default",
  "class_name" varchar(500) COLLATE "pg_catalog"."default",
  "method_name" varchar(500) COLLATE "pg_catalog"."default",
  "method_params_value" varchar(2000) COLLATE "pg_catalog"."default",
  "cron_expression" varchar(255) COLLATE "pg_catalog"."default",
  "job_message" varchar(500) COLLATE "pg_catalog"."default",
  "job_log_status" char(1) COLLATE "pg_catalog"."default",
  "execute_time" varchar(30) COLLATE "pg_catalog"."default",
  "exception_info" varchar(2000) COLLATE "pg_catalog"."default",
  "create_time" timestamp(6) NOT NULL
)
;
ALTER TABLE "pig"."sys_job_log" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."sys_job_log"."job_log_id" IS '任务日志ID';
COMMENT ON COLUMN "pig"."sys_job_log"."job_id" IS '任务id';
COMMENT ON COLUMN "pig"."sys_job_log"."job_name" IS '任务名称';
COMMENT ON COLUMN "pig"."sys_job_log"."job_group" IS '任务组名';
COMMENT ON COLUMN "pig"."sys_job_log"."job_order" IS '组内执行顺利，值越大执行优先级越高，最大值9，最小值1';
COMMENT ON COLUMN "pig"."sys_job_log"."job_type" IS '1、java类;2、spring bean名称;3、rest调用;4、jar调用;9其他';
COMMENT ON COLUMN "pig"."sys_job_log"."execute_path" IS 'job_type=3时，rest调用地址，仅支持post协议;job_type=4时，jar路径;其它值为空';
COMMENT ON COLUMN "pig"."sys_job_log"."class_name" IS 'job_type=1时，类完整路径;job_type=2时，spring bean名称;其它值为空';
COMMENT ON COLUMN "pig"."sys_job_log"."method_name" IS '任务方法';
COMMENT ON COLUMN "pig"."sys_job_log"."method_params_value" IS '参数值';
COMMENT ON COLUMN "pig"."sys_job_log"."cron_expression" IS 'cron执行表达式';
COMMENT ON COLUMN "pig"."sys_job_log"."job_message" IS '日志信息';
COMMENT ON COLUMN "pig"."sys_job_log"."job_log_status" IS '执行状态（0正常 1失败）';
COMMENT ON COLUMN "pig"."sys_job_log"."execute_time" IS '执行时间';
COMMENT ON COLUMN "pig"."sys_job_log"."exception_info" IS '异常信息';
COMMENT ON COLUMN "pig"."sys_job_log"."create_time" IS '创建时间';
COMMENT ON TABLE "pig"."sys_job_log" IS '定时任务执行日志表';

-- ----------------------------
-- Records of sys_job_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS "pig"."sys_log";
CREATE TABLE "pig"."sys_log" (
  "id" int8 NOT NULL,
  "log_type" char(1) COLLATE "pg_catalog"."default",
  "title" varchar(255) COLLATE "pg_catalog"."default",
  "service_id" varchar(32) COLLATE "pg_catalog"."default",
  "create_by" varchar(64) COLLATE "pg_catalog"."default",
  "update_by" varchar(64) COLLATE "pg_catalog"."default",
  "create_time" timestamp(6),
  "update_time" timestamp(6),
  "remote_addr" varchar(255) COLLATE "pg_catalog"."default",
  "user_agent" varchar(1000) COLLATE "pg_catalog"."default",
  "request_uri" varchar(255) COLLATE "pg_catalog"."default",
  "method" varchar(10) COLLATE "pg_catalog"."default",
  "params" text COLLATE "pg_catalog"."default",
  "time" int8,
  "del_flag" char(1) COLLATE "pg_catalog"."default",
  "exception" text COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "pig"."sys_log" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."sys_log"."id" IS '编号';
COMMENT ON COLUMN "pig"."sys_log"."log_type" IS '日志类型';
COMMENT ON COLUMN "pig"."sys_log"."title" IS '日志标题';
COMMENT ON COLUMN "pig"."sys_log"."service_id" IS '服务ID';
COMMENT ON COLUMN "pig"."sys_log"."create_by" IS '创建人';
COMMENT ON COLUMN "pig"."sys_log"."update_by" IS '修改人';
COMMENT ON COLUMN "pig"."sys_log"."create_time" IS '创建时间';
COMMENT ON COLUMN "pig"."sys_log"."update_time" IS '更新时间';
COMMENT ON COLUMN "pig"."sys_log"."remote_addr" IS '远程地址';
COMMENT ON COLUMN "pig"."sys_log"."user_agent" IS '用户代理';
COMMENT ON COLUMN "pig"."sys_log"."request_uri" IS '请求URI';
COMMENT ON COLUMN "pig"."sys_log"."method" IS '请求方法';
COMMENT ON COLUMN "pig"."sys_log"."params" IS '请求参数';
COMMENT ON COLUMN "pig"."sys_log"."time" IS '执行时间';
COMMENT ON COLUMN "pig"."sys_log"."del_flag" IS '删除标志';
COMMENT ON COLUMN "pig"."sys_log"."exception" IS '异常信息';
COMMENT ON TABLE "pig"."sys_log" IS '日志表';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS "pig"."sys_menu";
CREATE TABLE "pig"."sys_menu" (
  "menu_id" int8 NOT NULL,
  "name" varchar(32) COLLATE "pg_catalog"."default",
  "en_name" varchar(128) COLLATE "pg_catalog"."default",
  "permission" varchar(32) COLLATE "pg_catalog"."default",
  "path" varchar(128) COLLATE "pg_catalog"."default",
  "parent_id" int8,
  "icon" varchar(64) COLLATE "pg_catalog"."default",
  "visible" char(1) COLLATE "pg_catalog"."default",
  "sort_order" int4,
  "keep_alive" char(1) COLLATE "pg_catalog"."default",
  "embedded" char(1) COLLATE "pg_catalog"."default",
  "menu_type" char(1) COLLATE "pg_catalog"."default",
  "create_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "create_time" timestamp(6),
  "update_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "update_time" timestamp(6),
  "del_flag" char(1) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "pig"."sys_menu" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."sys_menu"."menu_id" IS '菜单ID';
COMMENT ON COLUMN "pig"."sys_menu"."name" IS '菜单名称';
COMMENT ON COLUMN "pig"."sys_menu"."en_name" IS '英文名称';
COMMENT ON COLUMN "pig"."sys_menu"."permission" IS '权限标识';
COMMENT ON COLUMN "pig"."sys_menu"."path" IS '路由路径';
COMMENT ON COLUMN "pig"."sys_menu"."parent_id" IS '父菜单ID';
COMMENT ON COLUMN "pig"."sys_menu"."icon" IS '菜单图标';
COMMENT ON COLUMN "pig"."sys_menu"."visible" IS '是否可见，0隐藏，1显示';
COMMENT ON COLUMN "pig"."sys_menu"."sort_order" IS '排序值，越小越靠前';
COMMENT ON COLUMN "pig"."sys_menu"."keep_alive" IS '是否缓存，0否，1是';
COMMENT ON COLUMN "pig"."sys_menu"."embedded" IS '是否内嵌，0否，1是';
COMMENT ON COLUMN "pig"."sys_menu"."menu_type" IS '菜单类型，0目录，1菜单，2按钮';
COMMENT ON COLUMN "pig"."sys_menu"."create_by" IS '创建人';
COMMENT ON COLUMN "pig"."sys_menu"."create_time" IS '创建时间';
COMMENT ON COLUMN "pig"."sys_menu"."update_by" IS '修改人';
COMMENT ON COLUMN "pig"."sys_menu"."update_time" IS '更新时间';
COMMENT ON COLUMN "pig"."sys_menu"."del_flag" IS '删除标志，0未删除，1已删除';
COMMENT ON TABLE "pig"."sys_menu" IS '菜单权限表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1000, '权限管理', 'authorization', NULL, '/admin', -1, 'iconfont icon-icon-', '1', 0, '0', '0', '0', '', '2018-09-28 08:29:53', 'admin', '2023-03-12 22:32:52', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1100, '用户管理', 'user', NULL, '/admin/user/index', 1000, 'ele-User', '1', 1, '0', '0', '0', '', '2017-11-02 22:24:37', 'admin', '2023-07-05 10:28:22', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1101, '用户新增', NULL, 'sys_user_add', NULL, 1100, NULL, '1', 1, '0', NULL, '1', ' ', '2017-11-08 09:52:09', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1102, '用户修改', NULL, 'sys_user_edit', NULL, 1100, NULL, '1', 1, '0', NULL, '1', ' ', '2017-11-08 09:52:48', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1103, '用户删除', NULL, 'sys_user_del', NULL, 1100, NULL, '1', 1, '0', NULL, '1', ' ', '2017-11-08 09:54:01', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1104, '导入导出', NULL, 'sys_user_export', NULL, 1100, NULL, '1', 1, '0', NULL, '1', ' ', '2017-11-08 09:54:01', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1200, '菜单管理', 'menu', NULL, '/admin/menu/index', 1000, 'iconfont icon-caidan', '1', 2, '0', '0', '0', '', '2017-11-08 09:57:27', 'admin', '2023-07-05 10:28:17', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1201, '菜单新增', NULL, 'sys_menu_add', NULL, 1200, NULL, '1', 1, '0', NULL, '1', ' ', '2017-11-08 10:15:53', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1202, '菜单修改', NULL, 'sys_menu_edit', NULL, 1200, NULL, '1', 1, '0', NULL, '1', ' ', '2017-11-08 10:16:23', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1203, '菜单删除', NULL, 'sys_menu_del', NULL, 1200, NULL, '1', 1, '0', NULL, '1', ' ', '2017-11-08 10:16:43', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1300, '角色管理', 'role', NULL, '/admin/role/index', 1000, 'iconfont icon-gerenzhongxin', '1', 3, '0', NULL, '0', '', '2017-11-08 10:13:37', 'admin', '2023-07-05 10:28:13', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1301, '角色新增', NULL, 'sys_role_add', NULL, 1300, NULL, '1', 1, '0', NULL, '1', ' ', '2017-11-08 10:14:18', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1302, '角色修改', NULL, 'sys_role_edit', NULL, 1300, NULL, '1', 1, '0', NULL, '1', ' ', '2017-11-08 10:14:41', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1303, '角色删除', NULL, 'sys_role_del', NULL, 1300, NULL, '1', 1, '0', NULL, '1', ' ', '2017-11-08 10:14:59', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1304, '分配权限', NULL, 'sys_role_perm', NULL, 1300, NULL, '1', 1, '0', NULL, '1', ' ', '2018-04-20 07:22:55', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1305, '角色导入导出', NULL, 'sys_role_export', NULL, 1300, NULL, '1', 4, '0', NULL, '1', ' ', '2022-03-26 15:54:34', ' ', NULL, '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1400, '部门管理', 'dept', NULL, '/admin/dept/index', 1000, 'iconfont icon-zidingyibuju', '1', 4, '0', NULL, '0', '', '2018-01-20 13:17:19', 'admin', '2023-07-05 10:28:07', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1401, '部门新增', NULL, 'sys_dept_add', NULL, 1400, NULL, '1', 1, '0', NULL, '1', ' ', '2018-01-20 14:56:16', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1402, '部门修改', NULL, 'sys_dept_edit', NULL, 1400, NULL, '1', 1, '0', NULL, '1', ' ', '2018-01-20 14:56:59', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1403, '部门删除', NULL, 'sys_dept_del', NULL, 1400, NULL, '1', 1, '0', NULL, '1', ' ', '2018-01-20 14:57:28', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1600, '岗位管理', 'post', NULL, '/admin/post/index', 1000, 'iconfont icon--chaifenhang', '1', 5, '1', '0', '0', '', '2022-03-26 13:04:14', 'admin', '2023-07-05 10:28:03', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1601, '岗位信息查看', NULL, 'sys_post_view', NULL, 1600, NULL, '1', 0, '0', NULL, '1', ' ', '2022-03-26 13:05:34', ' ', NULL, '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1602, '岗位信息新增', NULL, 'sys_post_add', NULL, 1600, NULL, '1', 1, '0', NULL, '1', ' ', '2022-03-26 13:06:00', ' ', NULL, '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1603, '岗位信息修改', NULL, 'sys_post_edit', NULL, 1600, NULL, '1', 2, '0', NULL, '1', ' ', '2022-03-26 13:06:31', ' ', '2022-03-26 13:06:38', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1604, '岗位信息删除', NULL, 'sys_post_del', NULL, 1600, NULL, '1', 3, '0', NULL, '1', ' ', '2022-03-26 13:06:31', ' ', NULL, '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (1605, '岗位导入导出', NULL, 'sys_post_export', NULL, 1600, NULL, '1', 4, '0', NULL, '1', ' ', '2022-03-26 13:06:31', ' ', '2022-03-26 06:32:02', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2000, '系统管理', 'system', NULL, '/system', -1, 'iconfont icon-quanjushezhi_o', '1', 1, '0', NULL, '0', '', '2017-11-07 20:56:00', 'admin', '2023-07-05 10:27:58', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2001, '日志管理', 'log', NULL, '/admin/logs', 2000, 'ele-Cloudy', '1', 0, '0', '0', '0', 'admin', '2023-03-02 12:26:42', 'admin', '2023-07-05 10:27:53', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2100, '操作日志', 'operation', NULL, '/admin/log/index', 2001, 'iconfont icon-jinridaiban', '1', 2, '0', '0', '0', '', '2017-11-20 14:06:22', 'admin', '2023-07-05 10:27:49', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2101, '日志删除', NULL, 'sys_log_del', NULL, 2100, NULL, '1', 1, '0', NULL, '1', ' ', '2017-11-20 20:37:37', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2102, '导入导出', NULL, 'sys_log_export', NULL, 2100, NULL, '1', 1, '0', NULL, '1', ' ', '2017-11-08 09:54:01', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2200, '字典管理', 'dict', NULL, '/admin/dict/index', 2000, 'iconfont icon-zhongduancanshuchaxun', '1', 6, '0', NULL, '0', '', '2017-11-29 11:30:52', 'admin', '2023-07-05 10:27:37', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2201, '字典删除', NULL, 'sys_dict_del', NULL, 2200, NULL, '1', 1, '0', NULL, '1', ' ', '2017-11-29 11:30:11', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2202, '字典新增', NULL, 'sys_dict_add', NULL, 2200, NULL, '1', 1, '0', NULL, '1', ' ', '2018-05-11 22:34:55', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2203, '字典修改', NULL, 'sys_dict_edit', NULL, 2200, NULL, '1', 1, '0', NULL, '1', ' ', '2018-05-11 22:36:03', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2210, '参数管理', 'parameter', NULL, '/admin/param/index', 2000, 'iconfont icon-wenducanshu-05', '1', 7, '1', NULL, '0', '', '2019-04-29 22:16:50', 'admin', '2023-02-16 15:24:51', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2211, '参数新增', NULL, 'sys_syspublicparam_add', NULL, 2210, NULL, '1', 1, '0', NULL, '1', ' ', '2019-04-29 22:17:36', ' ', '2020-03-24 08:57:11', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2212, '参数删除', NULL, 'sys_syspublicparam_del', NULL, 2210, NULL, '1', 1, '0', NULL, '1', ' ', '2019-04-29 22:17:55', ' ', '2020-03-24 08:57:12', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2213, '参数编辑', NULL, 'sys_syspublicparam_edit', NULL, 2210, NULL, '1', 1, '0', NULL, '1', ' ', '2019-04-29 22:18:14', ' ', '2020-03-24 08:57:13', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2300, '代码生成', 'code', NULL, '/gen/table/index', 9000, 'iconfont icon-zhongduancanshu', '1', 1, '0', '0', '0', '', '2018-01-20 13:17:19', 'admin', '2023-02-20 13:54:35', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2400, '终端管理', 'client', NULL, '/admin/client/index', 2000, 'iconfont icon-gongju', '1', 9, '1', NULL, '0', '', '2018-01-20 13:17:19', 'admin', '2023-02-16 15:25:28', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2401, '客户端新增', NULL, 'sys_client_add', NULL, 2400, '1', '1', 1, '0', NULL, '1', ' ', '2018-05-15 21:35:18', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2402, '客户端修改', NULL, 'sys_client_edit', NULL, 2400, NULL, '1', 1, '0', NULL, '1', ' ', '2018-05-15 21:37:06', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2403, '客户端删除', NULL, 'sys_client_del', NULL, 2400, NULL, '1', 1, '0', NULL, '1', ' ', '2018-05-15 21:39:16', ' ', '2021-05-25 03:12:55', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2600, '令牌管理', 'token', NULL, '/admin/token/index', 2000, 'ele-Key', '1', 11, '0', NULL, '0', '', '2018-09-04 05:58:41', 'admin', '2023-02-16 15:28:28', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2601, '令牌删除', NULL, 'sys_token_del', NULL, 2600, NULL, '1', 1, '0', NULL, '1', ' ', '2018-09-04 05:59:50', ' ', '2020-03-24 08:57:24', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2800, 'Quartz管理', 'quartz', NULL, '/daemon/job-manage/index', 2000, 'ele-AlarmClock', '1', 8, '0', NULL, '0', '', '2018-01-20 13:17:19', 'admin', '2023-02-16 15:25:06', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2810, '任务新增', NULL, 'job_sys_job_add', NULL, 2800, '1', '1', 0, '0', NULL, '1', ' ', '2018-05-15 21:35:18', ' ', '2020-03-24 08:57:26', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2820, '任务修改', NULL, 'job_sys_job_edit', NULL, 2800, '1', '1', 0, '0', NULL, '1', ' ', '2018-05-15 21:35:18', ' ', '2020-03-24 08:57:27', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2830, '任务删除', NULL, 'job_sys_job_del', NULL, 2800, '1', '1', 0, '0', NULL, '1', ' ', '2018-05-15 21:35:18', ' ', '2020-03-24 08:57:28', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2840, '任务暂停', NULL, 'job_sys_job_shutdown_job', NULL, 2800, '1', '1', 0, '0', NULL, '1', ' ', '2018-05-15 21:35:18', ' ', '2020-03-24 08:57:28', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2850, '任务开始', NULL, 'job_sys_job_start_job', NULL, 2800, '1', '1', 0, '0', NULL, '1', ' ', '2018-05-15 21:35:18', ' ', '2020-03-24 08:57:29', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2860, '任务刷新', NULL, 'job_sys_job_refresh_job', NULL, 2800, '1', '1', 0, '0', NULL, '1', ' ', '2018-05-15 21:35:18', ' ', '2020-03-24 08:57:30', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2870, '执行任务', NULL, 'job_sys_job_run_job', NULL, 2800, '1', '1', 0, '0', NULL, '1', ' ', '2019-08-08 15:35:18', ' ', '2020-03-24 08:57:31', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2871, '导出', NULL, 'job_sys_job_export', NULL, 2800, NULL, '1', 0, '0', '0', '1', 'admin', '2023-03-06 15:26:13', ' ', NULL, '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2906, '文件管理', 'file', NULL, '/admin/file/index', 2000, 'ele-Files', '1', 6, '0', NULL, '0', '', '2019-06-25 12:44:46', 'admin', '2023-02-16 15:24:42', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (2907, '删除文件', NULL, 'sys_file_del', NULL, 2906, NULL, '1', 1, '0', NULL, '1', ' ', '2019-06-25 13:41:41', ' ', '2020-03-24 08:58:42', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (4000, '系统监控', 'monitor', NULL, '/daemon', -1, 'iconfont icon-shuju', '1', 3, '0', '0', '0', 'admin', '2023-02-06 20:20:47', 'admin', '2023-02-23 20:01:07', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (4001, '文档扩展', 'doc', NULL, 'http://pig-gateway:9999/swagger-ui.html', 4000, 'iconfont icon-biaodan', '1', 2, '0', '1', '0', '', '2018-06-26 10:50:32', 'admin', '2023-02-23 20:01:29', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (4002, '缓存监控', 'cache', NULL, '/ext/cache', 4000, 'iconfont icon-shuju', '1', 1, '0', '0', '0', 'admin', '2023-05-29 15:12:59', 'admin', '2023-06-06 11:58:41', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9000, '开发平台', 'develop', NULL, '/gen', -1, 'iconfont icon-shuxingtu', '1', 9, '0', '0', '0', '', '2019-08-12 09:35:16', 'admin', '2023-07-05 10:25:27', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9005, '数据源管理', 'datasource', NULL, '/gen/datasource/index', 9000, 'ele-Coin', '1', 0, '0', NULL, '0', '', '2019-08-12 09:42:11', 'admin', '2023-07-05 10:26:56', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9006, '表单设计', 'Form Design', NULL, '/gen/design/index', 9000, 'iconfont icon-AIshiyanshi', '0', 2, '0', '0', '0', '', '2019-08-16 10:08:56', 'admin', '2023-02-23 14:06:50', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9007, '生成页面', 'generation', NULL, '/gen/gener/index', 9000, 'iconfont icon-tongzhi4', '0', 0, '0', '0', '0', 'admin', '2023-02-20 09:58:23', 'admin', '2023-07-05 10:27:06', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9050, '元数据管理', 'metadata', NULL, '/gen/metadata', 9000, 'iconfont icon--chaifenhang', '1', 9, '0', '0', '0', '', '2018-07-27 01:13:21', 'admin', '2023-07-05 10:27:13', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9051, '模板管理', 'template', NULL, '/gen/template/index', 9050, 'iconfont icon--chaifenhang', '1', 5, '0', '0', '0', 'admin', '2023-02-21 11:22:54', 'admin', '2023-07-05 10:27:18', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9052, '查询', NULL, 'codegen_template_view', NULL, 9051, NULL, '0', 0, '0', '0', '1', 'admin', '2023-02-21 12:33:03', 'admin', '2023-02-21 13:50:54', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9053, '增加', NULL, 'codegen_template_add', NULL, 9051, NULL, '1', 0, '0', '0', '1', 'admin', '2023-02-21 13:34:10', 'admin', '2023-02-21 13:39:49', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9054, '新增', NULL, 'codegen_template_add', NULL, 9051, NULL, '0', 1, '0', '0', '1', 'admin', '2023-02-21 13:51:32', ' ', NULL, '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9055, '导出', NULL, 'codegen_template_export', NULL, 9051, NULL, '0', 2, '0', '0', '1', 'admin', '2023-02-21 13:51:58', ' ', NULL, '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9056, '删除', NULL, 'codegen_template_del', NULL, 9051, NULL, '0', 3, '0', '0', '1', 'admin', '2023-02-21 13:52:16', ' ', NULL, '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9057, '编辑', NULL, 'codegen_template_edit', NULL, 9051, NULL, '0', 4, '0', '0', '1', 'admin', '2023-02-21 13:52:58', ' ', NULL, '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9059, '模板分组', 'group', NULL, '/gen/group/index', 9050, 'iconfont icon-shuxingtu', '1', 6, '0', '0', '0', 'admin', '2023-02-21 15:06:50', 'admin', '2023-07-05 10:27:22', '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9060, '查询', NULL, 'codegen_group_view', NULL, 9059, NULL, '0', 0, '0', '0', '1', 'admin', '2023-02-21 15:08:07', ' ', NULL, '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9061, '新增', NULL, 'codegen_group_add', NULL, 9059, NULL, '0', 0, '0', '0', '1', 'admin', '2023-02-21 15:08:28', ' ', NULL, '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9062, '修改', NULL, 'codegen_group_edit', NULL, 9059, NULL, '0', 0, '0', '0', '1', 'admin', '2023-02-21 15:08:43', ' ', NULL, '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9063, '删除', NULL, 'codegen_group_del', NULL, 9059, NULL, '0', 0, '0', '0', '1', 'admin', '2023-02-21 15:09:02', ' ', NULL, '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9064, '导出', NULL, 'codegen_group_export', NULL, 9059, NULL, '0', 0, '0', '0', '1', 'admin', '2023-02-21 15:09:22', ' ', NULL, '0');
INSERT INTO "pig"."sys_menu" ("menu_id", "name", "en_name", "permission", "path", "parent_id", "icon", "visible", "sort_order", "keep_alive", "embedded", "menu_type", "create_by", "create_time", "update_by", "update_time", "del_flag") VALUES (9065, '字段管理', 'field', NULL, '/gen/field-type/index', 9050, 'iconfont icon-fuwenben', '1', 0, '0', '0', '0', 'admin', '2023-02-23 20:05:09', 'admin', '2023-07-05 10:27:31', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_oauth_client_details
-- ----------------------------
DROP TABLE IF EXISTS "pig"."sys_oauth_client_details";
CREATE TABLE "pig"."sys_oauth_client_details" (
  "id" int8 NOT NULL,
  "client_id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "resource_ids" varchar(256) COLLATE "pg_catalog"."default",
  "client_secret" varchar(256) COLLATE "pg_catalog"."default",
  "scope" varchar(256) COLLATE "pg_catalog"."default",
  "authorized_grant_types" varchar(256) COLLATE "pg_catalog"."default",
  "web_server_redirect_uri" varchar(256) COLLATE "pg_catalog"."default",
  "authorities" varchar(256) COLLATE "pg_catalog"."default",
  "access_token_validity" int4,
  "refresh_token_validity" int4,
  "additional_information" varchar(4096) COLLATE "pg_catalog"."default",
  "autoapprove" varchar(256) COLLATE "pg_catalog"."default",
  "del_flag" char(1) COLLATE "pg_catalog"."default",
  "create_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "update_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "create_time" timestamp(6),
  "update_time" timestamp(6)
)
;
ALTER TABLE "pig"."sys_oauth_client_details" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."sys_oauth_client_details"."id" IS 'ID';
COMMENT ON COLUMN "pig"."sys_oauth_client_details"."client_id" IS '客户端ID';
COMMENT ON COLUMN "pig"."sys_oauth_client_details"."resource_ids" IS '资源ID集合';
COMMENT ON COLUMN "pig"."sys_oauth_client_details"."client_secret" IS '客户端秘钥';
COMMENT ON COLUMN "pig"."sys_oauth_client_details"."scope" IS '授权范围';
COMMENT ON COLUMN "pig"."sys_oauth_client_details"."authorized_grant_types" IS '授权类型';
COMMENT ON COLUMN "pig"."sys_oauth_client_details"."web_server_redirect_uri" IS '回调地址';
COMMENT ON COLUMN "pig"."sys_oauth_client_details"."authorities" IS '权限集合';
COMMENT ON COLUMN "pig"."sys_oauth_client_details"."access_token_validity" IS '访问令牌有效期（秒）';
COMMENT ON COLUMN "pig"."sys_oauth_client_details"."refresh_token_validity" IS '刷新令牌有效期（秒）';
COMMENT ON COLUMN "pig"."sys_oauth_client_details"."additional_information" IS '附加信息';
COMMENT ON COLUMN "pig"."sys_oauth_client_details"."autoapprove" IS '自动授权';
COMMENT ON COLUMN "pig"."sys_oauth_client_details"."del_flag" IS '删除标记，0未删除，1已删除';
COMMENT ON COLUMN "pig"."sys_oauth_client_details"."create_by" IS '创建人';
COMMENT ON COLUMN "pig"."sys_oauth_client_details"."update_by" IS '修改人';
COMMENT ON COLUMN "pig"."sys_oauth_client_details"."create_time" IS '创建时间';
COMMENT ON COLUMN "pig"."sys_oauth_client_details"."update_time" IS '更新时间';
COMMENT ON TABLE "pig"."sys_oauth_client_details" IS '终端信息表';

-- ----------------------------
-- Records of sys_oauth_client_details
-- ----------------------------
BEGIN;
INSERT INTO "pig"."sys_oauth_client_details" ("id", "client_id", "resource_ids", "client_secret", "scope", "authorized_grant_types", "web_server_redirect_uri", "authorities", "access_token_validity", "refresh_token_validity", "additional_information", "autoapprove", "del_flag", "create_by", "update_by", "create_time", "update_time") VALUES (1, 'app', NULL, 'app', 'server', 'password,refresh_token,authorization_code,client_credentials,mobile', 'http://localhost:4040/sso1/login,http://localhost:4041/sso1/login,http://localhost:8080/renren-admin/sys/oauth2-sso,http://localhost:8090/sys/oauth2-sso', NULL, 43200, 2592001, '{"enc_flag":"1","captcha_flag":"1","online_quantity":"1"}', 'true', '0', '', 'admin', NULL, '2023-02-09 13:54:54');
INSERT INTO "pig"."sys_oauth_client_details" ("id", "client_id", "resource_ids", "client_secret", "scope", "authorized_grant_types", "web_server_redirect_uri", "authorities", "access_token_validity", "refresh_token_validity", "additional_information", "autoapprove", "del_flag", "create_by", "update_by", "create_time", "update_time") VALUES (2, 'daemon', NULL, 'daemon', 'server', 'password,refresh_token', NULL, NULL, 43200, 2592001, '{"enc_flag":"1","captcha_flag":"1"}', 'true', '0', ' ', ' ', NULL, NULL);
INSERT INTO "pig"."sys_oauth_client_details" ("id", "client_id", "resource_ids", "client_secret", "scope", "authorized_grant_types", "web_server_redirect_uri", "authorities", "access_token_validity", "refresh_token_validity", "additional_information", "autoapprove", "del_flag", "create_by", "update_by", "create_time", "update_time") VALUES (3, 'gen', NULL, 'gen', 'server', 'password,refresh_token', NULL, NULL, 43200, 2592001, '{"enc_flag":"1","captcha_flag":"1"}', 'true', '0', ' ', ' ', NULL, NULL);
INSERT INTO "pig"."sys_oauth_client_details" ("id", "client_id", "resource_ids", "client_secret", "scope", "authorized_grant_types", "web_server_redirect_uri", "authorities", "access_token_validity", "refresh_token_validity", "additional_information", "autoapprove", "del_flag", "create_by", "update_by", "create_time", "update_time") VALUES (4, 'mp', NULL, 'mp', 'server', 'password,refresh_token', NULL, NULL, 43200, 2592001, '{"enc_flag":"1","captcha_flag":"1"}', 'true', '0', ' ', ' ', NULL, NULL);
INSERT INTO "pig"."sys_oauth_client_details" ("id", "client_id", "resource_ids", "client_secret", "scope", "authorized_grant_types", "web_server_redirect_uri", "authorities", "access_token_validity", "refresh_token_validity", "additional_information", "autoapprove", "del_flag", "create_by", "update_by", "create_time", "update_time") VALUES (5, 'pig', NULL, 'pig', 'server', 'password,refresh_token,authorization_code,client_credentials,mobile', 'http://localhost:4040/sso1/login,http://localhost:4041/sso1/login,http://localhost:8080/renren-admin/sys/oauth2-sso,http://localhost:8090/sys/oauth2-sso', NULL, 43200, 2592001, '{"enc_flag":"1","captcha_flag":"1","online_quantity":"1"}', 'false', '0', '', 'admin', NULL, '2023-03-08 11:32:41');
INSERT INTO "pig"."sys_oauth_client_details" ("id", "client_id", "resource_ids", "client_secret", "scope", "authorized_grant_types", "web_server_redirect_uri", "authorities", "access_token_validity", "refresh_token_validity", "additional_information", "autoapprove", "del_flag", "create_by", "update_by", "create_time", "update_time") VALUES (6, 'test', NULL, 'test', 'server', 'password,refresh_token', NULL, NULL, 43200, 2592001, '{ "enc_flag":"1","captcha_flag":"0"}', 'true', '0', ' ', ' ', NULL, NULL);
INSERT INTO "pig"."sys_oauth_client_details" ("id", "client_id", "resource_ids", "client_secret", "scope", "authorized_grant_types", "web_server_redirect_uri", "authorities", "access_token_validity", "refresh_token_validity", "additional_information", "autoapprove", "del_flag", "create_by", "update_by", "create_time", "update_time") VALUES (7, 'social', NULL, 'social', 'server', 'password,refresh_token,mobile', NULL, NULL, 43200, 2592001, '{ "enc_flag":"0","captcha_flag":"0"}', 'true', '0', ' ', ' ', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
DROP TABLE IF EXISTS "pig"."sys_post";
CREATE TABLE "pig"."sys_post" (
  "post_id" int8 NOT NULL,
  "post_code" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "post_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "post_sort" int4 NOT NULL,
  "remark" varchar(500) COLLATE "pg_catalog"."default",
  "del_flag" char(1) COLLATE "pg_catalog"."default" NOT NULL,
  "create_time" timestamp(6),
  "create_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "update_time" timestamp(6),
  "update_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL
)
;
ALTER TABLE "pig"."sys_post" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."sys_post"."post_id" IS '岗位ID';
COMMENT ON COLUMN "pig"."sys_post"."post_code" IS '岗位编码';
COMMENT ON COLUMN "pig"."sys_post"."post_name" IS '岗位名称';
COMMENT ON COLUMN "pig"."sys_post"."post_sort" IS '岗位排序';
COMMENT ON COLUMN "pig"."sys_post"."remark" IS '岗位描述';
COMMENT ON COLUMN "pig"."sys_post"."del_flag" IS '是否删除  -1：已删除  0：正常';
COMMENT ON COLUMN "pig"."sys_post"."create_time" IS '创建时间';
COMMENT ON COLUMN "pig"."sys_post"."create_by" IS '创建人';
COMMENT ON COLUMN "pig"."sys_post"."update_time" IS '更新时间';
COMMENT ON COLUMN "pig"."sys_post"."update_by" IS '更新人';
COMMENT ON TABLE "pig"."sys_post" IS '岗位信息表';

-- ----------------------------
-- Records of sys_post
-- ----------------------------
BEGIN;
INSERT INTO "pig"."sys_post" ("post_id", "post_code", "post_name", "post_sort", "remark", "del_flag", "create_time", "create_by", "update_time", "update_by") VALUES (1, 'CTO', 'CTO', 0, 'CTOOO', '0', '2022-03-26 13:48:17', '', '2023-03-08 16:03:35', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for sys_public_param
-- ----------------------------
DROP TABLE IF EXISTS "pig"."sys_public_param";
CREATE TABLE "pig"."sys_public_param" (
  "public_id" int8 NOT NULL,
  "public_name" varchar(128) COLLATE "pg_catalog"."default",
  "public_key" varchar(128) COLLATE "pg_catalog"."default",
  "public_value" varchar(128) COLLATE "pg_catalog"."default",
  "status" char(1) COLLATE "pg_catalog"."default",
  "validate_code" varchar(64) COLLATE "pg_catalog"."default",
  "create_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "update_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "create_time" timestamp(6) NOT NULL,
  "update_time" timestamp(6),
  "public_type" char(1) COLLATE "pg_catalog"."default",
  "system_flag" char(1) COLLATE "pg_catalog"."default",
  "del_flag" char(1) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "pig"."sys_public_param" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."sys_public_param"."public_id" IS '编号';
COMMENT ON COLUMN "pig"."sys_public_param"."public_name" IS '名称';
COMMENT ON COLUMN "pig"."sys_public_param"."public_key" IS '键';
COMMENT ON COLUMN "pig"."sys_public_param"."public_value" IS '值';
COMMENT ON COLUMN "pig"."sys_public_param"."status" IS '状态，0禁用，1启用';
COMMENT ON COLUMN "pig"."sys_public_param"."validate_code" IS '校验码';
COMMENT ON COLUMN "pig"."sys_public_param"."create_by" IS '创建人';
COMMENT ON COLUMN "pig"."sys_public_param"."update_by" IS '修改人';
COMMENT ON COLUMN "pig"."sys_public_param"."create_time" IS '创建时间';
COMMENT ON COLUMN "pig"."sys_public_param"."update_time" IS '更新时间';
COMMENT ON COLUMN "pig"."sys_public_param"."public_type" IS '类型，0未知，1系统，2业务';
COMMENT ON COLUMN "pig"."sys_public_param"."system_flag" IS '系统标识，0非系统，1系统';
COMMENT ON COLUMN "pig"."sys_public_param"."del_flag" IS '删除标记，0未删除，1已删除';
COMMENT ON TABLE "pig"."sys_public_param" IS '公共参数配置表';

-- ----------------------------
-- Records of sys_public_param
-- ----------------------------
BEGIN;
INSERT INTO "pig"."sys_public_param" ("public_id", "public_name", "public_key", "public_value", "status", "validate_code", "create_by", "update_by", "create_time", "update_time", "public_type", "system_flag", "del_flag") VALUES (1, '租户默认来源', 'TENANT_DEFAULT_ID', '1', '0', '', ' ', ' ', '2020-05-12 04:03:46', '2020-06-20 08:56:30', '2', '0', '1');
INSERT INTO "pig"."sys_public_param" ("public_id", "public_name", "public_key", "public_value", "status", "validate_code", "create_by", "update_by", "create_time", "update_time", "public_type", "system_flag", "del_flag") VALUES (2, '租户默认部门名称', 'TENANT_DEFAULT_DEPTNAME', '租户默认部门', '0', '', ' ', ' ', '2020-05-12 03:36:32', NULL, '2', '1', '0');
INSERT INTO "pig"."sys_public_param" ("public_id", "public_name", "public_key", "public_value", "status", "validate_code", "create_by", "update_by", "create_time", "update_time", "public_type", "system_flag", "del_flag") VALUES (3, '租户默认账户', 'TENANT_DEFAULT_USERNAME', 'admin', '0', '', ' ', ' ', '2020-05-12 04:05:04', NULL, '2', '1', '0');
INSERT INTO "pig"."sys_public_param" ("public_id", "public_name", "public_key", "public_value", "status", "validate_code", "create_by", "update_by", "create_time", "update_time", "public_type", "system_flag", "del_flag") VALUES (4, '租户默认密码', 'TENANT_DEFAULT_PASSWORD', '123456', '0', '', ' ', ' ', '2020-05-12 04:05:24', NULL, '2', '1', '0');
INSERT INTO "pig"."sys_public_param" ("public_id", "public_name", "public_key", "public_value", "status", "validate_code", "create_by", "update_by", "create_time", "update_time", "public_type", "system_flag", "del_flag") VALUES (5, '租户默认角色编码', 'TENANT_DEFAULT_ROLECODE', 'ROLE_ADMIN', '0', '', ' ', ' ', '2020-05-12 04:05:57', NULL, '2', '1', '0');
INSERT INTO "pig"."sys_public_param" ("public_id", "public_name", "public_key", "public_value", "status", "validate_code", "create_by", "update_by", "create_time", "update_time", "public_type", "system_flag", "del_flag") VALUES (6, '租户默认角色名称', 'TENANT_DEFAULT_ROLENAME', '租户默认角色', '0', '', ' ', ' ', '2020-05-12 04:06:19', NULL, '2', '1', '0');
INSERT INTO "pig"."sys_public_param" ("public_id", "public_name", "public_key", "public_value", "status", "validate_code", "create_by", "update_by", "create_time", "update_time", "public_type", "system_flag", "del_flag") VALUES (7, '表前缀', 'GEN_TABLE_PREFIX', 'tb_', '0', '', ' ', ' ', '2020-05-12 04:23:04', NULL, '9', '1', '0');
INSERT INTO "pig"."sys_public_param" ("public_id", "public_name", "public_key", "public_value", "status", "validate_code", "create_by", "update_by", "create_time", "update_time", "public_type", "system_flag", "del_flag") VALUES (8, '接口文档不显示的字段', 'GEN_HIDDEN_COLUMNS', 'tenant_id', '0', '', ' ', ' ', '2020-05-12 04:25:19', NULL, '9', '1', '0');
INSERT INTO "pig"."sys_public_param" ("public_id", "public_name", "public_key", "public_value", "status", "validate_code", "create_by", "update_by", "create_time", "update_time", "public_type", "system_flag", "del_flag") VALUES (9, '注册用户默认角色', 'USER_DEFAULT_ROLE', 'GENERAL_USER', '0', NULL, ' ', ' ', '2022-03-31 16:52:24', NULL, '2', '1', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS "pig"."sys_role";
CREATE TABLE "pig"."sys_role" (
  "role_id" int8 NOT NULL,
  "role_name" varchar(64) COLLATE "pg_catalog"."default",
  "role_code" varchar(64) COLLATE "pg_catalog"."default",
  "role_desc" varchar(255) COLLATE "pg_catalog"."default",
  "create_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "update_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "create_time" timestamp(6) NOT NULL,
  "update_time" timestamp(6),
  "del_flag" char(1) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "pig"."sys_role" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."sys_role"."role_id" IS '角色ID';
COMMENT ON COLUMN "pig"."sys_role"."role_name" IS '角色名称';
COMMENT ON COLUMN "pig"."sys_role"."role_code" IS '角色编码';
COMMENT ON COLUMN "pig"."sys_role"."role_desc" IS '角色描述';
COMMENT ON COLUMN "pig"."sys_role"."create_by" IS '创建人';
COMMENT ON COLUMN "pig"."sys_role"."update_by" IS '修改人';
COMMENT ON COLUMN "pig"."sys_role"."create_time" IS '创建时间';
COMMENT ON COLUMN "pig"."sys_role"."update_time" IS '更新时间';
COMMENT ON COLUMN "pig"."sys_role"."del_flag" IS '删除标记，0未删除，1已删除';
COMMENT ON TABLE "pig"."sys_role" IS '系统角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO "pig"."sys_role" ("role_id", "role_name", "role_code", "role_desc", "create_by", "update_by", "create_time", "update_time", "del_flag") VALUES (1, '管理员', 'ROLE_ADMIN', '管理员', '', 'admin', '2017-10-29 15:45:51', '2023-07-07 14:55:07', '0');
INSERT INTO "pig"."sys_role" ("role_id", "role_name", "role_code", "role_desc", "create_by", "update_by", "create_time", "update_time", "del_flag") VALUES (2, '普通用户', 'GENERAL_USER', '普通用户', '', 'admin', '2022-03-31 17:03:15', '2023-04-03 02:28:51', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS "pig"."sys_role_menu";
CREATE TABLE "pig"."sys_role_menu" (
  "role_id" int8 NOT NULL,
  "menu_id" int8 NOT NULL
)
;
ALTER TABLE "pig"."sys_role_menu" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."sys_role_menu"."role_id" IS '角色ID';
COMMENT ON COLUMN "pig"."sys_role_menu"."menu_id" IS '菜单ID';
COMMENT ON TABLE "pig"."sys_role_menu" IS '角色菜单表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1000);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1100);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1101);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1102);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1103);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1104);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1200);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1201);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1202);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1203);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1300);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1301);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1302);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1303);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1304);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1305);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1400);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1401);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1402);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1403);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1600);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1601);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1602);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1603);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1604);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 1605);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2000);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2001);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2100);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2101);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2102);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2200);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2201);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2202);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2203);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2210);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2211);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2212);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2213);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2300);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2400);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2401);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2402);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2403);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2600);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2601);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2800);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2810);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2820);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2830);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2840);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2850);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2860);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2870);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2871);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2906);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 2907);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 4000);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 4001);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 4002);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9000);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9005);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9006);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9007);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9050);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9051);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9052);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9053);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9054);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9055);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9056);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9057);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9059);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9060);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9061);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9062);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9063);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9064);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (1, 9065);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (2, 4000);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (2, 4001);
INSERT INTO "pig"."sys_role_menu" ("role_id", "menu_id") VALUES (2, 4002);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS "pig"."sys_user";
CREATE TABLE "pig"."sys_user" (
  "user_id" int8 NOT NULL,
  "username" varchar(64) COLLATE "pg_catalog"."default",
  "password" varchar(255) COLLATE "pg_catalog"."default",
  "salt" varchar(255) COLLATE "pg_catalog"."default",
  "phone" varchar(20) COLLATE "pg_catalog"."default",
  "avatar" varchar(255) COLLATE "pg_catalog"."default",
  "nickname" varchar(64) COLLATE "pg_catalog"."default",
  "name" varchar(64) COLLATE "pg_catalog"."default",
  "email" varchar(128) COLLATE "pg_catalog"."default",
  "dept_id" int8,
  "create_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "update_by" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "create_time" timestamp(6),
  "update_time" timestamp(6),
  "lock_flag" char(1) COLLATE "pg_catalog"."default",
  "del_flag" char(1) COLLATE "pg_catalog"."default",
  "wx_openid" varchar(32) COLLATE "pg_catalog"."default",
  "mini_openid" varchar(32) COLLATE "pg_catalog"."default",
  "qq_openid" varchar(32) COLLATE "pg_catalog"."default",
  "gitee_login" varchar(100) COLLATE "pg_catalog"."default",
  "osc_id" varchar(100) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "pig"."sys_user" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."sys_user"."user_id" IS '用户ID';
COMMENT ON COLUMN "pig"."sys_user"."username" IS '用户名';
COMMENT ON COLUMN "pig"."sys_user"."password" IS '密码';
COMMENT ON COLUMN "pig"."sys_user"."salt" IS '盐值';
COMMENT ON COLUMN "pig"."sys_user"."phone" IS '电话号码';
COMMENT ON COLUMN "pig"."sys_user"."avatar" IS '头像';
COMMENT ON COLUMN "pig"."sys_user"."nickname" IS '昵称';
COMMENT ON COLUMN "pig"."sys_user"."name" IS '姓名';
COMMENT ON COLUMN "pig"."sys_user"."email" IS '邮箱地址';
COMMENT ON COLUMN "pig"."sys_user"."dept_id" IS '所属部门ID';
COMMENT ON COLUMN "pig"."sys_user"."create_by" IS '创建人';
COMMENT ON COLUMN "pig"."sys_user"."update_by" IS '修改人';
COMMENT ON COLUMN "pig"."sys_user"."create_time" IS '创建时间';
COMMENT ON COLUMN "pig"."sys_user"."update_time" IS '修改时间';
COMMENT ON COLUMN "pig"."sys_user"."lock_flag" IS '锁定标记，0未锁定，9已锁定';
COMMENT ON COLUMN "pig"."sys_user"."del_flag" IS '删除标记，0未删除，1已删除';
COMMENT ON COLUMN "pig"."sys_user"."wx_openid" IS '微信登录openId';
COMMENT ON COLUMN "pig"."sys_user"."mini_openid" IS '小程序openId';
COMMENT ON COLUMN "pig"."sys_user"."qq_openid" IS 'QQ openId';
COMMENT ON COLUMN "pig"."sys_user"."gitee_login" IS '码云标识';
COMMENT ON COLUMN "pig"."sys_user"."osc_id" IS '开源中国标识';
COMMENT ON TABLE "pig"."sys_user" IS '用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO "pig"."sys_user" ("user_id", "username", "password", "salt", "phone", "avatar", "nickname", "name", "email", "dept_id", "create_by", "update_by", "create_time", "update_time", "lock_flag", "del_flag", "wx_openid", "mini_openid", "qq_openid", "gitee_login", "osc_id") VALUES (1, 'admin', '$2a$10$c/Ae0pRjJtMZg3BnvVpO.eIK6WYWVbKTzqgdy3afR7w.vd.xi3Mgy', '', '17034642999', '/admin/sys-file/s3demo/7ff4ca6b7bf446f3a5a13ac016dc21af.png', '管理员', '管理员', 'pig4cloud@qq.com', 4, ' ', 'admin', '2018-04-20 07:15:18', '2023-07-07 14:55:40', '0', '0', NULL, 'oBxPy5E-v82xWGsfzZVzkD3wEX64', NULL, 'log4j', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_post
-- ----------------------------
DROP TABLE IF EXISTS "pig"."sys_user_post";
CREATE TABLE "pig"."sys_user_post" (
  "user_id" int8 NOT NULL,
  "post_id" int8 NOT NULL
)
;
ALTER TABLE "pig"."sys_user_post" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."sys_user_post"."user_id" IS '用户ID';
COMMENT ON COLUMN "pig"."sys_user_post"."post_id" IS '岗位ID';
COMMENT ON TABLE "pig"."sys_user_post" IS '用户与岗位关联表';

-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
BEGIN;
INSERT INTO "pig"."sys_user_post" ("user_id", "post_id") VALUES (1, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS "pig"."sys_user_role";
CREATE TABLE "pig"."sys_user_role" (
  "user_id" int8 NOT NULL,
  "role_id" int8 NOT NULL
)
;
ALTER TABLE "pig"."sys_user_role" OWNER TO "postgres";
COMMENT ON COLUMN "pig"."sys_user_role"."user_id" IS '用户ID';
COMMENT ON COLUMN "pig"."sys_user_role"."role_id" IS '角色ID';
COMMENT ON TABLE "pig"."sys_user_role" IS '用户角色表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO "pig"."sys_user_role" ("user_id", "role_id") VALUES (1, 1);
INSERT INTO "pig"."sys_user_role" ("user_id", "role_id") VALUES (1676492190299299842, 2);
COMMIT;

-- ----------------------------
-- Primary Key structure for table QRTZ_BLOB_TRIGGERS
-- ----------------------------
ALTER TABLE "pig"."QRTZ_BLOB_TRIGGERS" ADD CONSTRAINT "QRTZ_BLOB_TRIGGERS_pkey" PRIMARY KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Primary Key structure for table QRTZ_CALENDARS
-- ----------------------------
ALTER TABLE "pig"."QRTZ_CALENDARS" ADD CONSTRAINT "QRTZ_CALENDARS_pkey" PRIMARY KEY ("SCHED_NAME", "CALENDAR_NAME");

-- ----------------------------
-- Primary Key structure for table QRTZ_CRON_TRIGGERS
-- ----------------------------
ALTER TABLE "pig"."QRTZ_CRON_TRIGGERS" ADD CONSTRAINT "QRTZ_CRON_TRIGGERS_pkey" PRIMARY KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Primary Key structure for table QRTZ_FIRED_TRIGGERS
-- ----------------------------
ALTER TABLE "pig"."QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "QRTZ_FIRED_TRIGGERS_pkey" PRIMARY KEY ("SCHED_NAME", "ENTRY_ID");

-- ----------------------------
-- Primary Key structure for table QRTZ_JOB_DETAILS
-- ----------------------------
ALTER TABLE "pig"."QRTZ_JOB_DETAILS" ADD CONSTRAINT "QRTZ_JOB_DETAILS_pkey" PRIMARY KEY ("SCHED_NAME", "JOB_NAME", "JOB_GROUP");

-- ----------------------------
-- Primary Key structure for table QRTZ_LOCKS
-- ----------------------------
ALTER TABLE "pig"."QRTZ_LOCKS" ADD CONSTRAINT "QRTZ_LOCKS_pkey" PRIMARY KEY ("SCHED_NAME", "LOCK_NAME");

-- ----------------------------
-- Primary Key structure for table QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
ALTER TABLE "pig"."QRTZ_PAUSED_TRIGGER_GRPS" ADD CONSTRAINT "QRTZ_PAUSED_TRIGGER_GRPS_pkey" PRIMARY KEY ("SCHED_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Primary Key structure for table QRTZ_SCHEDULER_STATE
-- ----------------------------
ALTER TABLE "pig"."QRTZ_SCHEDULER_STATE" ADD CONSTRAINT "QRTZ_SCHEDULER_STATE_pkey" PRIMARY KEY ("SCHED_NAME", "INSTANCE_NAME");

-- ----------------------------
-- Primary Key structure for table QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
ALTER TABLE "pig"."QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT "QRTZ_SIMPLE_TRIGGERS_pkey" PRIMARY KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Primary Key structure for table QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
ALTER TABLE "pig"."QRTZ_SIMPROP_TRIGGERS" ADD CONSTRAINT "QRTZ_SIMPROP_TRIGGERS_pkey" PRIMARY KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Indexes structure for table QRTZ_TRIGGERS
-- ----------------------------
CREATE INDEX "SCHED_NAME" ON "pig"."QRTZ_TRIGGERS" USING btree (
  "SCHED_NAME" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "JOB_NAME" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "JOB_GROUP" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);

-- ----------------------------
-- Primary Key structure for table QRTZ_TRIGGERS
-- ----------------------------
ALTER TABLE "pig"."QRTZ_TRIGGERS" ADD CONSTRAINT "QRTZ_TRIGGERS_pkey" PRIMARY KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Primary Key structure for table gen_datasource_conf
-- ----------------------------
ALTER TABLE "pig"."gen_datasource_conf" ADD CONSTRAINT "gen_datasource_conf_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Indexes structure for table gen_field_type
-- ----------------------------
CREATE UNIQUE INDEX "column_type" ON "pig"."gen_field_type" USING btree (
  "column_type" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);

-- ----------------------------
-- Primary Key structure for table gen_field_type
-- ----------------------------
ALTER TABLE "pig"."gen_field_type" ADD CONSTRAINT "gen_field_type_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Primary Key structure for table gen_group
-- ----------------------------
ALTER TABLE "pig"."gen_group" ADD CONSTRAINT "gen_group_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Indexes structure for table gen_table
-- ----------------------------
CREATE UNIQUE INDEX "table_name" ON "pig"."gen_table" USING btree (
  "table_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "ds_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);

-- ----------------------------
-- Primary Key structure for table gen_table
-- ----------------------------
ALTER TABLE "pig"."gen_table" ADD CONSTRAINT "gen_table_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Primary Key structure for table gen_table_column
-- ----------------------------
ALTER TABLE "pig"."gen_table_column" ADD CONSTRAINT "gen_table_column_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Primary Key structure for table gen_template
-- ----------------------------
ALTER TABLE "pig"."gen_template" ADD CONSTRAINT "gen_template_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Primary Key structure for table gen_template_group
-- ----------------------------
ALTER TABLE "pig"."gen_template_group" ADD CONSTRAINT "gen_template_group_pkey" PRIMARY KEY ("group_id", "template_id");

-- ----------------------------
-- Primary Key structure for table sys_dept
-- ----------------------------
ALTER TABLE "pig"."sys_dept" ADD CONSTRAINT "sys_dept_pkey" PRIMARY KEY ("dept_id");

-- ----------------------------
-- Indexes structure for table sys_dict
-- ----------------------------
CREATE INDEX "sys_dict_del_flag" ON "pig"."sys_dict" USING btree (
  "del_flag" COLLATE "pg_catalog"."default" "pg_catalog"."bpchar_ops" ASC NULLS LAST
);

-- ----------------------------
-- Primary Key structure for table sys_dict
-- ----------------------------
ALTER TABLE "pig"."sys_dict" ADD CONSTRAINT "sys_dict_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Indexes structure for table sys_dict_item
-- ----------------------------
CREATE INDEX "sys_dict_item_del_flag" ON "pig"."sys_dict_item" USING btree (
  "del_flag" COLLATE "pg_catalog"."default" "pg_catalog"."bpchar_ops" ASC NULLS LAST
);
CREATE INDEX "sys_dict_label" ON "pig"."sys_dict_item" USING btree (
  "label" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "sys_dict_value" ON "pig"."sys_dict_item" USING btree (
  "item_value" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);

-- ----------------------------
-- Primary Key structure for table sys_dict_item
-- ----------------------------
ALTER TABLE "pig"."sys_dict_item" ADD CONSTRAINT "sys_dict_item_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Primary Key structure for table sys_file
-- ----------------------------
ALTER TABLE "pig"."sys_file" ADD CONSTRAINT "sys_file_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Indexes structure for table sys_job
-- ----------------------------
CREATE UNIQUE INDEX "job_name_group_idx" ON "pig"."sys_job" USING btree (
  "job_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "job_group" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);

-- ----------------------------
-- Primary Key structure for table sys_job
-- ----------------------------
ALTER TABLE "pig"."sys_job" ADD CONSTRAINT "sys_job_pkey" PRIMARY KEY ("job_id");

-- ----------------------------
-- Primary Key structure for table sys_job_log
-- ----------------------------
ALTER TABLE "pig"."sys_job_log" ADD CONSTRAINT "sys_job_log_pkey" PRIMARY KEY ("job_log_id");

-- ----------------------------
-- Indexes structure for table sys_log
-- ----------------------------
CREATE INDEX "sys_log_create_date" ON "pig"."sys_log" USING btree (
  "create_time" "pg_catalog"."timestamp_ops" ASC NULLS LAST
);
CREATE INDEX "sys_log_request_uri" ON "pig"."sys_log" USING btree (
  "request_uri" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "sys_log_type" ON "pig"."sys_log" USING btree (
  "log_type" COLLATE "pg_catalog"."default" "pg_catalog"."bpchar_ops" ASC NULLS LAST
);

-- ----------------------------
-- Primary Key structure for table sys_log
-- ----------------------------
ALTER TABLE "pig"."sys_log" ADD CONSTRAINT "sys_log_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Primary Key structure for table sys_menu
-- ----------------------------
ALTER TABLE "pig"."sys_menu" ADD CONSTRAINT "sys_menu_pkey" PRIMARY KEY ("menu_id");

-- ----------------------------
-- Primary Key structure for table sys_oauth_client_details
-- ----------------------------
ALTER TABLE "pig"."sys_oauth_client_details" ADD CONSTRAINT "sys_oauth_client_details_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Primary Key structure for table sys_post
-- ----------------------------
ALTER TABLE "pig"."sys_post" ADD CONSTRAINT "sys_post_pkey" PRIMARY KEY ("post_id");

-- ----------------------------
-- Primary Key structure for table sys_public_param
-- ----------------------------
ALTER TABLE "pig"."sys_public_param" ADD CONSTRAINT "sys_public_param_pkey" PRIMARY KEY ("public_id");

-- ----------------------------
-- Indexes structure for table sys_role
-- ----------------------------
CREATE INDEX "role_idx1_role_code" ON "pig"."sys_role" USING btree (
  "role_code" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);

-- ----------------------------
-- Primary Key structure for table sys_role
-- ----------------------------
ALTER TABLE "pig"."sys_role" ADD CONSTRAINT "sys_role_pkey" PRIMARY KEY ("role_id");

-- ----------------------------
-- Primary Key structure for table sys_role_menu
-- ----------------------------
ALTER TABLE "pig"."sys_role_menu" ADD CONSTRAINT "sys_role_menu_pkey" PRIMARY KEY ("role_id", "menu_id");

-- ----------------------------
-- Indexes structure for table sys_user
-- ----------------------------
CREATE INDEX "user_idx1_username" ON "pig"."sys_user" USING btree (
  "username" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "user_qq_openid" ON "pig"."sys_user" USING btree (
  "qq_openid" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "user_wx_openid" ON "pig"."sys_user" USING btree (
  "wx_openid" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);

-- ----------------------------
-- Primary Key structure for table sys_user
-- ----------------------------
ALTER TABLE "pig"."sys_user" ADD CONSTRAINT "sys_user_pkey" PRIMARY KEY ("user_id");

-- ----------------------------
-- Primary Key structure for table sys_user_post
-- ----------------------------
ALTER TABLE "pig"."sys_user_post" ADD CONSTRAINT "sys_user_post_pkey" PRIMARY KEY ("user_id", "post_id");

-- ----------------------------
-- Primary Key structure for table sys_user_role
-- ----------------------------
ALTER TABLE "pig"."sys_user_role" ADD CONSTRAINT "sys_user_role_pkey" PRIMARY KEY ("user_id", "role_id");

-- ----------------------------
-- Foreign Keys structure for table QRTZ_BLOB_TRIGGERS
-- ----------------------------
ALTER TABLE "pig"."QRTZ_BLOB_TRIGGERS" ADD CONSTRAINT "QRTZ_BLOB_TRIGGERS_ibfk_1" FOREIGN KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") REFERENCES "pig"."QRTZ_TRIGGERS" ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") ON DELETE NO ACTION ON UPDATE NO ACTION;

-- ----------------------------
-- Foreign Keys structure for table QRTZ_CRON_TRIGGERS
-- ----------------------------
ALTER TABLE "pig"."QRTZ_CRON_TRIGGERS" ADD CONSTRAINT "QRTZ_CRON_TRIGGERS_ibfk_1" FOREIGN KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") REFERENCES "pig"."QRTZ_TRIGGERS" ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") ON DELETE NO ACTION ON UPDATE NO ACTION;

-- ----------------------------
-- Foreign Keys structure for table QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
ALTER TABLE "pig"."QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT "QRTZ_SIMPLE_TRIGGERS_ibfk_1" FOREIGN KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") REFERENCES "pig"."QRTZ_TRIGGERS" ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") ON DELETE NO ACTION ON UPDATE NO ACTION;

-- ----------------------------
-- Foreign Keys structure for table QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
ALTER TABLE "pig"."QRTZ_SIMPROP_TRIGGERS" ADD CONSTRAINT "QRTZ_SIMPROP_TRIGGERS_ibfk_1" FOREIGN KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") REFERENCES "pig"."QRTZ_TRIGGERS" ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") ON DELETE NO ACTION ON UPDATE NO ACTION;

-- ----------------------------
-- Foreign Keys structure for table QRTZ_TRIGGERS
-- ----------------------------
ALTER TABLE "pig"."QRTZ_TRIGGERS" ADD CONSTRAINT "QRTZ_TRIGGERS_ibfk_1" FOREIGN KEY ("SCHED_NAME", "JOB_NAME", "JOB_GROUP") REFERENCES "pig"."QRTZ_JOB_DETAILS" ("SCHED_NAME", "JOB_NAME", "JOB_GROUP") ON DELETE NO ACTION ON UPDATE NO ACTION;
